Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel save takes 18 times longer than Windows Explorer copy - why?Options
Hi All
I have an Excel system with about 10 sheets and loads of VBA modules and classes. It resides on a network at my company's headquarters. When I copy the file from my desktop to the server using Windows Explorer drag and drop it takes about 6 seconds. However if I open the Excel file from the server from my PC and save it using Excel the save time is 90 seconds. Is this normal? My users are complaining about the time it takes to save after editing. It also means that they are not saving often and are risking losing changes. Any thoughts? If the length of my save is normal then what should I do to reduce the size of my file for a quicker save? How much does VBA code add to the file size or should I be looking at the size of each worksheet? Cheers Chrisso |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel save takes 18 times longer than Windows Explorer copy - why?Options
When you simply drag and drop Excel does not need to make any calculations, however when the workbook is opened/closed calculations may take place, try setting calculation to manual in the beforesave event or beforeclose event, like this: With Application ..Calculation = xlManual ..MaxChange = 0.001 ..CalculateBeforeSave = False End With don't forget to turn it back on in the open event! Chrisso;628211 Wrote: Hi All I have an Excel system with about 10 sheets and loads of VBA modules and classes. It resides on a network at my company's headquarters. When I copy the file from my desktop to the server using Windows Explorer drag and drop it takes about 6 seconds. However if I open the Excel file from the server from my PC and save it using Excel the save time is 90 seconds. Is this normal? My users are complaining about the time it takes to save after editing. It also means that they are not saving often and are risking losing changes. Any thoughts? If the length of my save is normal then what should I do to reduce the size of my file for a quicker save? How much does VBA code add to the file size or should I be looking at the size of each worksheet? Cheers Chrisso -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=174829 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel save takes 18 times longer than Windows Explorer copy - why?Options
"Simon Lloyd" wrote:
try setting calculation to manual in the beforesave event or beforeclose event, like this: With Application Calculation = xlManual MaxChange = 0.001 CalculateBeforeSave = False End With But don't forget the dots before property names; to wit: With Application .Calculation = xlManual .MaxChange = 0.001 .CalculateBeforeSave = False End With And should MaxChange really be part of the process? We do see it when we record a macro while setting the manual calculation option. But then again, we also see PrecisionAsDisplayed being set, yet we are wise enough to recognize that as extraneous. ----- original message ----- "Simon Lloyd" wrote in message ... When you simply drag and drop Excel does not need to make any calculations, however when the workbook is opened/closed calculations may take place, try setting calculation to manual in the beforesave event or beforeclose event, like this: With Application Calculation = xlManual MaxChange = 0.001 CalculateBeforeSave = False End With don't forget to turn it back on in the open event! Chrisso;628211 Wrote: Hi All I have an Excel system with about 10 sheets and loads of VBA modules and classes. It resides on a network at my company's headquarters. When I copy the file from my desktop to the server using Windows Explorer drag and drop it takes about 6 seconds. However if I open the Excel file from the server from my PC and save it using Excel the save time is 90 seconds. Is this normal? My users are complaining about the time it takes to save after editing. It also means that they are not saving often and are risking losing changes. Any thoughts? If the length of my save is normal then what should I do to reduce the size of my file for a quicker save? How much does VBA code add to the file size or should I be looking at the size of each worksheet? Cheers Chrisso -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=174829 Microsoft Office Help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel save takes 18 times longer than Windows Explorer copy -why?Options
On 30 Jan, 08:59, Simon Lloyd
wrote: When you simply drag and drop Excel does not need to make any calculations, however when the workbook is opened/closed calculations may take place, try setting calculation to manual in the beforesave event or beforeclose event, like this: With Application .Calculation = xlManual .MaxChange = 0.001 .CalculateBeforeSave = False End With don't forget to turn it back on in the open event! Chrisso;628211 Wrote: Hi All I have an Excel system with about 10 sheets and loads of VBA modules and classes. It resides on a network at my company's headquarters. When I copy the file from my desktop to the server using Windows Explorer drag and drop it takes about 6 seconds. However if I open the Excel file from the server from my PC and save it using Excel the save time is 90 seconds. Is this normal? My users are complaining about the time it takes to save after editing. It also means that they are not saving often and are risking losing changes. Any thoughts? If the length of my save is normal then what should I do to reduce the size of my file for a quicker save? How much does VBA code add to the file size or should I be looking at the size of each worksheet? Cheers Chrisso -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=174829 Microsoft Office Help- Hide quoted text - - Show quoted text - Thanks - i will give it a try. Chrisso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel save takes 18 times longer than Windows Explorer copy - why? | Excel Programming | |||
Any way to copy file names in windows explorer & paste into Excel? | Excel Discussion (Misc queries) | |||
Copy the "Title" Field from windows explorer to excel? | New Users to Excel | |||
Excel VBA project explorer no longer available | Excel Programming | |||
Save takes seconds vs. SaveAs/Save As takes minutes | Excel Programming |