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 ,
"Donald Speirs" 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?