LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 93
Default Why doesn't Excel understand what 'Manual' for Calculations?

Excel crashed and 'recovered' a worksheet and in the process removed critical
indents on over 25,000 records, the indents which are being used for a
critical final stage calculation.

Fortuneatly I had run an 'Indent' function to store the values so the actual
indents didn't matter anymore.

However i noticed as I made changes (e.g. removed a sheet, saved) it would
recalculate the entire workbook.

SO I set Calculations to Manual. Which to me means. Manual.

Now I made additions to a sheet and am saving and Excel, thinking somehow
Manual means Excel Manual keeps rerunning the Indent script which is
re-setting the critically previously correct indent values to 0.

Can't I just save and/or make changes without Excel AUTOMATICALLY
recalculating since I am asking to MANUALLY recalculate????
 
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 can i get MANUAL CALCULATIONS p e r m a n e n t l y Chicago man Setting up and Configuration of Excel 1 August 29th 06 03:56 AM
Automatic and manual calculations bpeltzer Excel Discussion (Misc queries) 0 March 20th 06 02:49 PM
tools helping understand calculations Dmitry Kopnichev Excel Discussion (Misc queries) 5 October 4th 05 06:37 AM
tools helping understand calculations Dmitry Kopnichev Excel Worksheet Functions 5 October 4th 05 06:37 AM
Excel Calculations Open in Manual Occasionally rich32822 Excel Discussion (Misc queries) 1 February 17th 05 09:25 PM


All times are GMT +1. The time now is 09:55 PM.

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"