Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Faster Excel Saves??
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Faster Excel Saves??
There are some suggested reasons for slow open/close at
http://www.decisionmodels.com/optspeedd.htm#OpSave and see also David McRitchies page at http://www.mvps.org/dmcritchie/excel/slowresp.htm Once you have identified the reason you may be able to improve things. regards Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Faster Excel Saves??
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 "Dave Peterson" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Faster Excel Saves??
Charles, thanks. I'm already jumping on these links and they are very
helpful! Thanks, John "Charles Williams" wrote: There are some suggested reasons for slow open/close at http://www.decisionmodels.com/optspeedd.htm#OpSave and see also David McRitchies page at http://www.mvps.org/dmcritchie/excel/slowresp.htm Once you have identified the reason you may be able to improve things. regards Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel saves to wrong folder | Excel Discussion (Misc queries) | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel saves the path of the printer with the document. | Excel Discussion (Misc queries) |