Why doesn't Excel understand what 'Manual' for Calculations?

  • Thread starter Thread starter msnyc07
  • Start date Start date
M

msnyc07

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????
 
Hi msnyc07,
Excel Manual keeps rerunning the Indent script which is
re-setting the critically previously correct indent values to 0.
Click to expand...

Do you have a macro set to run on the Worksheet_Change event?
Perhaps it should be the Worksheet_Calculate event.

Ed Ferrero
www.edferrero.com
 
No, it is just a basic function in a cell (column) on multiple sheets. I was
trying to do it so when i made changes to a *sheet* I could just say
'Calculate Sheet' but that isn't working.
 
Their is a check box just below the option button for manual calculation. It
is Recalculate Before Save. If you do not want it to recalculate before save
just uncheck the box.
 
And note that, if you're using a workbook that's in an older format, Excel re-calculates it on opening regardless of the calculation
settings.
 
Back
Top