Manual Calculation in Excel 2000

[Guest]

When I click Tools, Options, Calculation, and choose Manual, Excel continues
to calculate automatically. How can I get Excel to calculate manually when I
choose that option?

 

[Guest]

Did you click OK after you selected "Manual" in the Calculation tab ?

 

[Guest]

Yes, I clicked OK.

Did you click OK after you selected "Manual" in the Calculation tab ?

 

[Max]

Yes, I clicked OK.

Then it should have worked

But the calc mode setting per Excel session is dependent on the calc mode of
the 1st book that was open. It the 1st book was on auto mode, then
subsequent books opened in the same session would have their calc modes on
auto, irregardless of their previous saved calc modes.

Perhaps you were experiencing the above?

---

 

[Guest]

No, that's not the problem. I'm thinking my program was corrupted during an
automatic update from Microsoft because the same thing happens with the
program on my laptop. I can't make Excel keep the setting I choose. It worked
properly in the past. I was hoping if someone else has experienced this, they
would have a solution.

Thanks.

 

[Max]

I'm out here. Perhaps there's a chance other responders would have insights
to share with you. You may wish to put in a new posting, with the full
details as elaborated. Good luck.

 

[Dave Peterson]

What do you mean that you can't make excel keep this setting?

When does excel lose the setting--when you close excel and reopen it?

When you open another workbook in that same session?

 

[Guest]

I have a a workbook session open and am using a spreadsheet I have created. I
don't want the formulas to automatically calculate. So I go to Tools,
Options, Calculation, and choose Manual, OK. That closes the dialog box. I
enter a formula and it still automatically calculates.

I discovered that one clue is "re" in recalculate. It will enter the
original calculation automatically as soon as the formula is entered. If
there is a change in any of the rows or cells, F9 must be pressed to
"re"calculate. That works.

However, if I close the spreadsheet and reopen the spreadsheet, the option
has gone back to Automatic. My question is why it doesn't remain on Manual
until I change it?

dm

 

[Dave Peterson]

Excel determines what calculation setting to use based on the first workbook
(even personal.xls) that's opened in that session.

My guess is that you're opening a workbook with automatic calculation first.

I have a a workbook session open and am using a spreadsheet I have created. I
don't want the formulas to automatically calculate. So I go to Tools,
Options, Calculation, and choose Manual, OK. That closes the dialog box. I
enter a formula and it still automatically calculates.

I discovered that one clue is "re" in recalculate. It will enter the
original calculation automatically as soon as the formula is entered. If
there is a change in any of the rows or cells, F9 must be pressed to
"re"calculate. That works.

However, if I close the spreadsheet and reopen the spreadsheet, the option
has gone back to Automatic. My question is why it doesn't remain on Manual
until I change it?

dm

 

[Guest]

Sorry, that's not the answer because the problem occurs on my desktop
computer but not on my laptop. Using the same program and file on the
laptop, the manual calculation setting stays as is until I change it. The
setting only affects the workbook I've changed it on no matter how often I
open and close that or any other workbook.

My conclusion is the desktop program has a bug.

Thanks for trying. dm

 

[Dave Peterson]

I don't think so.

I'm still betting that you have another workbook that opens and tells excel how
to treat the calculation setting.

If I were you, I'd look to see what other files are opened when excel starts.

Sorry, that's not the answer because the problem occurs on my desktop
computer but not on my laptop. Using the same program and file on the
laptop, the manual calculation setting stays as is until I change it. The
setting only affects the workbook I've changed it on no matter how often I
open and close that or any other workbook.

My conclusion is the desktop program has a bug.

Thanks for trying. dm

 

[Guest]

I already tried that. No other workbooks were open.

dm