dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
600
share rss forum feed


R2
R Not
Premium,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.

aroberti
Sarcastic? Me? Never
Premium
join:2000-12-21
Norwalk, CT
Click for full size
Here's where it is in 2010. Hopefully it's similar enough to point you in the right direction.


R2
R Not
Premium,MVM
join:2000-09-18
Long Beach, CA
kudos:1
Thanks!


2kmaro
Think
Premium,ExMod 1 BC
join:2000-07-11
ColossalCave
kudos:1
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.


R2
R Not
Premium,MVM
join:2000-09-18
Long Beach, CA
kudos:1
Oy vay! Thanks, 2k. Long time....