2003 Excel Macros Run Slowly

[Ed H]

I upgraded to Office 2003 and have a macro in one of my
spreadsheets. When I execute this macro it runs very,
very slowly i.e. mulitple minutes vs 2 sec on Office
2000. Is there anything I should be doing to improve the
speed?

Regards,
Ed

 

[Dave Peterson]

Close excel, clean up your windows temp folder.

set calculation to manual, run your code, reset it to what it was.
Turn screenupdating off when you start and on when you finish.
turn the display of pagebreaks off when you start.


Lots of my macros have this at the top:

Dim CalcMode As Long
CalcMode = Application.Calculation
Application.Calculation = xlCalculationManual
ActiveSheet.DisplayPageBreaks = False

and near the bottom:

Application.Calculation = CalcMode
Application.ScreenUpdating = True