Excel Extremely Slow

[KMH]

I have a file that should work fine, but is incredibly slow to navigate in
2007. It takes over 30 seconds to just open a row group and running some
macros that require calculations on slows it down from seconds to minutes. I
am going to try it in Excel 2003 on an old computer as well to see if 2003 to
2007 is the issue, but any help or suggestions are appreciated.

Description of file...
Laptop is HP 8730W 3 GHz 3GB RAM
Windows XP Professional Version 2002 SP2
~4MB in size Excel 2007 now but originated in 2003
Primary Worksheet = about 4000 rows and only about 64 columns
There is quite a bit of conditional formatting and formatting in general but
nothing Excel 2003 couldn't handle.
A few offset functions but these are disabled in an IF statement
A few IRR calcuations that returned #NUM or DIV#0 but these have been
disabled via IF statement (If(Iserror(....))
I used to have a short macro that worked in the background if the sheet
changed, but that is turned off now as well.
There are no data tables or pivot tables in the sheet. Therefore changing
to automatic calcs without tables won't help.



Is there any way to dedicate more resources to Excel or find out where
exactly Excel is bogging down????

Thanks

 

[Shane Devenshire]

Hi,

There are innumerable ways to speed up macros including
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

remember to turn the second one back on when the code is finished.

The use of large numbers of volatile functions can slow down Excel, as well
as lots of graphics. Graphics are more of an issue in 2007 because the
graphic quality is so much greater. To handle graphics you need a powerful
graphics card, not just a fast computer.

The following functions are volatile

RAND(), NOW(), TODAY()
OFFSET(), CELL(), INDIRECT(), INFO()
CELL()

 

[Don Guillett]

I have both versions and can take a look.
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.