Excel 2000 vs 2003
I have a rather large Workbook, 50Megs, that when I open in Excel 2000 it
takes about 1 minute to open, but once open the Macros take no more than 30
seconds for the most complex macro.
When I use Excel 2003, the same file takes about :10 seconds to open, but
the same macros take as long as 5 minutes? Why and is there a way I can
speed up the macros when they run? Its more important for the macros to
run faster than it is for the file to open. I did stop the error checking,
but that did not help.
--
MJM
|