Calculation settings in Excel

April 2, 2009 at 19:09:09
Specs: Windows XP
In windows XP Pro, Office 2003: Excel reverts back to manual calculation automatically and repeatedly. How to set it that it stays on automatic calculation?

See More: Calculation settings in Excel

Report •


#1
April 2, 2009 at 19:14:10
On the Tool Bar,
Tools,
Options,
Calculation Tab
Tick "Automatic"

Should do it.....

MIKE

http://www.skeptic.com/


Report •

#2
April 3, 2009 at 12:19:37
Yes, I know that. The problem is that for some reason after a while the automatic calculation get set back to manual....
I have seen this happen several times. Even while working in the same file.

Report •

#3
April 3, 2009 at 13:03:04
Try doing a Detect & Repair?

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
April 3, 2009 at 20:16:25
I believe Excel sets it's calculation mode based on the first workbook that is opened during a given session.

Is it possible that these "random" occurrences are happening because some other already-opened workbook was set to manual and therefore impacted any other files opened during that session?


Report •

#5
April 3, 2009 at 21:06:41
Hmmm, I don't know. I am a long time user of Excel (>10 years) and I have not seen this happening previously. I also tried to change the setting in the hidden Personal.xls but it did not have an effect.
Thanks for your suggestions. I also will do a Detect and Repair, as soon as I get an installation CD from our IT dept.
Weird.....


Report •

#6
April 4, 2009 at 17:34:32
I'm sure you are very proud of your Excel longevity.

Here's what I did:

1 - Opened Excel
2 - Open an existing workbook from my system
3 - Set Calculation to Manual
4 - Saved the workbook and closed Excel
5 - Opened Excel
6 - Checked Calculation to ensure it was Automatic by default - it was
7 - Opened the workbook that I had saved as Manual
8 - Tested the workbook to ensure it was Manual - it was
- Result: Every other workbook I opened during that session was set to Manual
9 - Closed Excel without saving any workbooks
10 - Opened Excel
11 - Opened a workbook that I had not saved as Manual
12 - Tested it to ensure it was set to Automatic - it was
13 - Opened the workbook that I had saved as Manual
14 - Tested it and found it was set to Automatic

It appears to me that Excel sets it's calculation mode based on the first workbook that is opened during a given session.

Thus my question...

Is it possible that these "random" occurrences are happening because some other already-opened workbook was set to manual and therefore impacted any other files opened during that session?


Report •

#7
April 4, 2009 at 19:14:18
Thanks for that test. I did the same test with the same results. Yet, the reverting happens. Not right away but after 1 or 2 hours of Excel use.

As far as your question goes: I always set the calculation to automatic as soon as I found it was manual. I never set it to manual myself. After that these files are saved. I have to assume they are set to automatic when I reopen them. But I have not checked that systematically.

I have come up with another hypothesis: an interference with addons. I need to check with our IT guys who may have installed something that I am not aware of. I appreciate your help sofar and I will keep you updated if I find out more.

At least I have not found any clues that Excel has a hidden (registry) tweak that would switch calculation to manual if the files are (getting) too big. Or...?

Thanks again!


Report •

#8
April 4, 2009 at 21:14:50
Found this:

http://excel.tips.net/Pages/T001988...

Could this be what's happening?

MIKE

http://www.skeptic.com/


Report •

#9
May 1, 2009 at 17:22:16
I have finally found it!
It was a bug in ASAP Utilities that happened in the version up to 4.5.1. It is now fixed, see http://www.asap-utilities.com/faq-q...

Report •


Ask Question