View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeM MikeM is offline
external usenet poster
 
Posts: 64
Default 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