Macros make file saving extremely slow.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros making file saving extremely slow. 1
Lose macros before saving 4
Macros not found and macro toolbars 0
file size makes no sense! 2
Saving a Word document as PDF from en Excel macro 2
Excel .xlsm / Vista / Speed Problem 12
stop excel updating from word 2
Save As Macro Script 6

Back
Top