Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Carobar
 
Posts: n/a
Default Speeding Saving Process

Excel saves take nearly 10 minutes, how can I quicken the process. Or, what
should I look at to determine why it is taking so long.
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Carobar,

One or more sheets in your workbook may have a used range which is larger
than you expect or intend.

See Debra Dalgleish's notes at:

http://www.contextures.com/xlfaqApp.html#Unused

---
Regards,
Norman



"Carobar" wrote in message
...
Excel saves take nearly 10 minutes, how can I quicken the process. Or,
what
should I look at to determine why it is taking so long.



  #3   Report Post  
Phil Osman
 
Posts: n/a
Default

How big is your workbook in terms of MB ?

Also, try to eliminate big sections of VLookup formulas as I find them the
worst offenders. They can often be replaced with a SumProduct formula which I
would be happy to help with if you post some of your formulas here.

Phil

"Carobar" wrote:

Excel saves take nearly 10 minutes, how can I quicken the process. Or, what
should I look at to determine why it is taking so long.

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
How do I stop Excel 2000 from saving file history from file that . Cathy Excel Discussion (Misc queries) 0 March 29th 05 03:27 PM
Saving shared Excel files scasawyer New Users to Excel 3 February 7th 05 02:21 PM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 02:17 PM
Simplify Process with Excel 2003 Zraxius New Users to Excel 1 December 5th 04 01:55 PM
Error Message appearing when saving a file JaneC Excel Discussion (Misc queries) 0 November 25th 04 10:35 PM


All times are GMT +1. The time now is 08: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"