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?

Did you click OK after you selected "Manual" in the Calculation tab ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dm" wrote:
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?

Yes, I clicked OK.

"Max" wrote:

Did you click OK after you selected "Manual" in the Calculation tab ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dm" wrote:
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?

"dm" wrote:
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?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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" wrote:

"dm" wrote:
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?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dm" wrote in message
...
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.

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?



dm wrote:

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" wrote:

"dm" wrote:
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?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---




--

Dave Peterson