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

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

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
 
M

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top