View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Faster Excel Saves??

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


" wrote in
message ...
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