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.

There have been a number of postings of a bug with conditional formatting
and Excel 2007. It seems that copying and pasting results in multiple sets
of conditional formats. And having lots of conditional formatting appears
to greatly slow down Excel 2007. The only solution if this is what is
happening is a bug fix from Microsoft. Only Microsoft knows when that will
happen.

Robert Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"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.