 R2R NotPremium,MVM
join:2000-09-18
Long Beach, CA
kudos:1 | [Excel] (2007) AutoReCalculate turned off? I normally expect my Excel enties to Auto-Re-Calculate if I change the data in a cell that is used in a formula. Well, in one of my files this has been inadvertently turned off. There is now a little "Calculate" button I must hit in the Status bar - or I am left with the prior calculated data in the subsequent cell.
How can I turn back on the AutoReCalculate function? Thank you. |
|
arobertiSarcastic? Me? NeverPremium
join:2000-12-21
Norwalk, CT | Here's where it is in 2010. Hopefully it's similar enough to point you in the right direction. |
|
R2R NotPremium,MVM
join:2000-09-18
Long Beach, CA
kudos:1 | Thanks! |
|
 2kmaroThinkPremium,ExMod 1 BC
join:2000-07-11
ColossalCave | reply to R2
There's also a rather ugly side effect of this (and this might partially explain how you got there suddenly):
The Calculate mode of the first file opened after you open Excel propogates to all other Excel files opened during that same session with Excel!
So if you open a file with Calculation set to manual, any other files you open without first closing Excel will also get set to manual. Then later when they are the first file open, they "set the standard" so to speak. It can get ugly quick.
--
...then THINK! again. |
|
|
|
R2R NotPremium,MVM
join:2000-09-18
Long Beach, CA
kudos:1 | Oy vay! Thanks, 2k. Long time.... |
|
