Excel 2010 Severe Performance Problem
Posted on 2010-11-22
We have a machine running Excel 2010 on a Windows 7 Professional 64-bit Intel i7 Processor running about 3GB of RAM.
When my user opens a local native version of .xlsx document it takes over 30seconds to load and when doing some of the most basic alterations to the spreadsheet, the changes take literally minutes to complete.
One example would be selecting a column and unbolding the content of all rows in that column. The spreadsheet has just over 100,000 rows with about 3 formulas. We purchased Excel 2010 in an effort to move beyond the 50,000 row limit of older Excel versions, but we honestly did not expect the performance to be this bad.
Has anyone seen any similar problems and are there any workarounds/solutions?