My macros run considerably slower in Excel 2003 than they do in Excel XP. Any
suggestions why, and can it be improved?
--
Regards
R. Gavey

My response is that speed improvements that work in XL 2002
would also work in XL 2003.

Each version seems to run a little slower than the previous version.
When comparing adjacent releases you generally cannot tell the
difference without timing the code. (xl 2007 may be an exception)

Make sure that the amount of data you are processing is not
greater than that used in xl2002. For instance if you are running
nested loops - then just a small increase in the amount of data can
measurably increase the processing time required.

Also, clean out the Windows temp folder: %temp%, made sure
ScreenUpdating is turned off and page breaks are not displayed.
Some anti-virus programs work like a dragging anchor on Office programs.
Try disabling what you got and see if it makes a difference.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Richard Gavey"

wrote in message
My macros run considerably slower in Excel 2003 than they do in Excel XP. Any
suggestions why, and can it be improved?
--
Regards
R. Gavey