Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default Excel save takes 18 times longer than Windows Explorer copy - why?

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any way to copy file names in windows explorer & paste into Excel? Jason Excel Discussion (Misc queries) 3 January 15th 07 09:14 PM
Copy the "Title" Field from windows explorer to excel? [email protected] New Users to Excel 1 June 30th 06 09:58 PM
Excel VBA project explorer no longer available Hans Bergman[_2_] Excel Programming 3 January 25th 06 02:06 PM
Windows Explorer maximizes over XL 2000, if opened w/ explorer bill Excel Discussion (Misc queries) 2 June 28th 05 02:53 PM
Save takes seconds vs. SaveAs/Save As takes minutes Andrew H[_3_] Excel Programming 0 August 17th 04 07:17 PM


All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"