M
MikeM
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 Macro’s 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 macro’s take as long as 5 minutes? Why and is there a way I can
speed up the macro’s when they run? Its more important for the macro’s to
run faster than it is for the file to open. I did stop the error checking,
but that did not help.
takes about 1 minute to open, but once open the Macro’s 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 macro’s take as long as 5 minutes? Why and is there a way I can
speed up the macro’s when they run? Its more important for the macro’s to
run faster than it is for the file to open. I did stop the error checking,
but that did not help.