Macros making file saving extremely slow.

[Guest]

Hello,

I have an Excel spreadsheet with over one hundred small Macros embedded
within it. Although the spreadsheet is only a modest size (approx 1.5MB), it
takes an extremely long time to save (usually several minutes).

I suspect the Macros have increased the number of file addresses needed to
create the spreadsheet file, which is the reason for the increase in the save
time. Is there any way of addressing this problem short of deleting the
Macros?

many thanks,

Donald Speirs (Scotland).

 

[Dave Peterson]

I've never seen the existence of macros have this behavior.

But maybe...

Try closing excel and cleaning up your windows temp folder--it might help and it
can't hurt.

And here are a couple of sites that discuss slow performance. The first is by
Charles Williams and the second by David McRitchie:

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm

(I don't recall anything directly on point--but you may find something that
helps.)