LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Time required to 'save as' a large file

Hi!

I have a user who has a 14M workbook which has 26 worksheets. Each of the
worksheets has many (up to several hundred) large calculations. If you open
the workbook, work on it and save it to the same location it takes a minute
or so to save. If you do a file save and save it in another location, either
locally or on the network, the file takes up to twenty minutes to save. We
removed the Recalculate before save option hopes that it would speed things
up but it makes no difference.

Does anyone know 1) what cause this prolonged save time and 2) is there any
way to speed it up. This problem occurs on several of their large workbooks.


--
Thanks - MKL
 
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
Can you save 1 sheet from a large file into another file? imktew Excel Worksheet Functions 2 January 17th 08 05:46 AM
Save a large file Kassandra Excel Discussion (Misc queries) 3 April 23rd 07 09:14 PM
Time it takes to save my file Andre Setting up and Configuration of Excel 1 December 28th 06 12:12 AM
customer date time save file Robert Loxley Excel Discussion (Misc queries) 0 October 30th 06 05:36 PM
Time Required to Save a File John M Excel Discussion (Misc queries) 1 September 24th 05 12:00 AM


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

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

About Us

"It's about Microsoft Excel"