View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Faster Excel Saves??

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.

wrote:

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


--

Dave Peterson