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.)

Donald Speirs wrote:
>
> 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