Macros make file saving extremely slow.

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

Even a hundred macros shouldn't slow down a Save that much.

Do you have any workbook-level event macros running, esp.
Workbook_BeforeSave()? If so, look to that macro.




In article <BA5A2D17-59E3-46CE-8439-A1D4F64B07EC@microsoft.com>,
"Donald Speirs" <DonaldSpeirs@discussions.microsoft.com> wrote:

> 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?