Well now the ability of Excel to handle more than 65K rows seems more like a curse than anything else!! Recently, I exported an Access table to Excel and it took around 30 minutes. Not too mention that the process hogged all of my systems resources and locked up my machine. Now whenever I try to open that spreadsheet in Excel it takes at least another 5 minutes to open it!
I'm running an IBM (Lenovo) T43 Thinkpad with a 1.86 GHz Pentium M processor and 1.5 GB of 782 MHz RAM. My operating system is XP Pro w/ SP3. Anybody got any ideas as to why this is such a painful process and how to speed it up? Or is that just the way it is? Would kind of defeat the purpose of increasing the capacity of Excel if it is!!