Earlier this year my company upgraded all of us to Office 2007. I read about some of the changes and was somewhat excited!
Like the ability to have spreadsheets of more than 65K rows and 256 columns. In my job duties I often look at data in Access that is hundreds of thousands of lines long. More than 256 columns seldom comes into play , it's really the rows that initially made me happy. Now I could export these large tables to excel spreadsheets and manipulate the data in excel.
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!!
Login 
Business Applications 
