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 |
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 |