Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kjetil
 
Posts: n/a
Default "Manual calculation" takes less time. Why?

An excel workbook (approx 10 MB) compiled from a 3rd party program used to
take 30 minutes to save.

After choosing "manual calculation before saving" saving time was reduced to
3 minutes.

Curious to know why...

Thanks in advance!

Kjetil


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you just force a recalculation (without the save), how long does that take?

(I don't have a guess when you answer it's not close to 30 minutes!)

Kjetil wrote:

An excel workbook (approx 10 MB) compiled from a 3rd party program used to
take 30 minutes to save.

After choosing "manual calculation before saving" saving time was reduced to
3 minutes.

Curious to know why...

Thanks in advance!

Kjetil


--

Dave Peterson
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
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 09:25 AM
Calculating Time in XP takes forever Dan Excel Discussion (Misc queries) 3 December 22nd 04 11:06 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 03:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 01:07 AM
Excel - Time calculation Leyland Excel Discussion (Misc queries) 1 November 30th 04 08:43 PM


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