750 KB file saves 10 times longer than a 900 KB file

[Guest]

We use a spreadsheet in our office that has numerous macros. This spreadsheet is approximately 750 kb. I created another file with no macros that is about 900 kb. The 900 kb file saves enormously faster that the 750 kb file with macros

I spend a lot of time waiting for these files to save all day long. I have tried moving the macros to another sheet to see if that would help - but it only helped minutely. I have no add-ins checked (I saw that suggestion on another post). Any suggestions are hugely appreciated. Thank you.

 

[Dave Peterson]

I've never noticed a difference in time based on if a workbook contains macros
(discounting a misbehaving macro).

Are you saving to the same location in your tests--local harddrive for both or
common share for both?

Any chance you can disable the antivirus software to see if that's interferring
with your save.

 

[Guest]

Hello Dave

Thanks for considering this situation. I reallize there could be a number of things causing the long save??

Anyway, I don't have any antivirus software installed. I double checked the saving time for the 900 kb file in the same location as the 750 kb file, and it was still extremely faster. Neither of the files are shared (is that what you meant?)

I also had a friend save the same file on their computer and it took at long time too

Is there a chance that during the saving process the spreadsheet is updating other files? I don't intend to update any other files with this spreadsheet, but there could be a cell in there somewhere that I don't know about trying to update another document - I have seen that happen when copying & pasting between two open documents. Again, I don't intend for it to do that if that is the case

Your continued help on this is greatly appreciated. Thank you

- Davi

----- Dave Peterson wrote: ----

I've never noticed a difference in time based on if a workbook contains macro
(discounting a misbehaving macro)

Are you saving to the same location in your tests--local harddrive for both o
common share for both

Any chance you can disable the antivirus software to see if that's interferrin
with your save



David P. wrote

 

[Dave Peterson]

From a couple of private emails:

I've never seen just that cause problems. Are you saving to a Network drive.

I have seen posts that say that some workbooks with userforms could have slow
saves.

Maybe someone will jump in the newsgroup thread.

===

I searched the MS knowledge base and found these:

http://support.microsoft.com/search...dType=ALL&maxResults=150&Titles=false&numDays

If clicking on that doesn't work, this should be all one line and then paste it
into your browser.