Help Optimizing a Sheet to improve performance

  • Thread starter Thread starter Vulcan
  • Start date Start date
V

Vulcan

Hi:

I have a large excel sheet with lots and lots of formulas - many of them
text related, and lots of conditional formatting. The response of the sheet
is very slow - that is, when I enter a value in a cell, it can take up to a
second or more before the conditional formatting changes the appearance of
the cell. I'm also sung some 'grouping' which has an extremely slow
response. Expanding the to first level can take half a minute and there are
only about 40 rows in the sheet.

Aside from the obvious - reducing formulas and conditional formatting rules,
is there a general way to optimize a sheet for speed? Thanks for any
suggestions.

Office 2007 running under Vista on a high speed Quad Core machine with 4 gig
of memory.
 
"Never Upgrade"...
Some possible help here (pack a lunch)...
http://msdn.microsoft.com/en-us/library/aa730921.aspx
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Vulcan"
wrote in message
Hi:
I have a large excel sheet with lots and lots of formulas - many of them
text related, and lots of conditional formatting. The response of the sheet
is very slow - that is, when I enter a value in a cell, it can take up to a
second or more before the conditional formatting changes the appearance of
the cell. I'm also sung some 'grouping' which has an extremely slow
response. Expanding the to first level can take half a minute and there are
only about 40 rows in the sheet.
Aside from the obvious - reducing formulas and conditional formatting rules,
is there a general way to optimize a sheet for speed? Thanks for any
suggestions.
Office 2007 running under Vista on a high speed Quad Core machine with 4 gig
of memory.
 
Back
Top