Which factors result in the most "sluggishness" in Excel?
Posted on 2011-10-22
I'm trying to determine sort of a "sluggishness scale" regarding which factors have the greatest effect on slowing down basic functions in an Excel spreadsheet.
For example, I have a spreadsheet with data entries in rows 1:21000. In that spreadsheet, doing even the most basic functions is exceedingly slow. As a result, I'm trying to determine which bells and whistles I can eliminate to get the greatest improvement in processing speed.
Some of the bells and whistles include:
Color formatting of both fonts and fill
Outlining (using Group & Ungroup)
There are others but those are the ones that come to mind. There's nothing exotic but this particular spreadsheet is so slow that I would call it dysfunctional. Therefore it definitely needs therapy -- I'm just trying to determine which therapeutic approach might be most effective!
PS Obviously, a slow computer can result in the same problem. That's not the issue here though as this particular computer has plenty of oomph plus if I Copy/PasteValue the entire contents into a new spreadsheet, it zips along just fine. :)