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

[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????

 

[Ed Ferrero]

Hi msnyc07,

Excel Manual keeps rerunning the Indent script which is
re-setting the critically previously correct indent values to 0.

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

 

[msnyc07]

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.

 

[Jim Thomlinson]

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.

 

[macropod]

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.