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

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

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

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

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.

"Ed Ferrero" wrote:

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
.

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

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.
--
HTH...

Jim Thomlinson


"msnyc07" wrote:

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

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

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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Jim Thomlinson" wrote in message
...
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.
--
HTH...

Jim Thomlinson


"msnyc07" wrote:

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