Faster Excel Saves??

J

JohnC

I have a 4 MB Excel file running VBA which is made up mostly of 7 fairly
large macros and some data.

When I save the file, it takes about 2 1/2 minutes....and during the Save
process, the Task Manager is showing "Not Resonding", until the thing finally
settles down after the 2.5 minutes.

Is there any way to implement a faster save time? Apparently Word and PPT
have the Fast Save feature, but Excel doesn't.

Thanks,
John
 
D

Dave Peterson

If you're not saving to your local harddrive, maybe you can try that.

Then use windows explorer to copy that file to where you want it.
 
J

Jon Peltier

Fast Save adds the changes to the file, so the file size increases, and
reopening the file takes longer as the original version is opened than
subsequent changes are made, during the file open process. Most experts
recommend against this option.

- Jon
 
J

JohnC

Dave: Good idea. My save time to hard drive took 6 seconds!
Jon: Cool stuff in the links. Thanks much. I was hoping that there were
some temp files building up that I could delete.
You guys do provide valuable service and help.
Thanks,
John
 
J

JohnC

Charles, thanks. I'm already jumping on these links and they are very
helpful! Thanks, John
 
Top