a protected cell w/formula only updates only on file save?

S

snap

I have an excel worksheet that use to work fine. Now all of a sudden the cell
with a formula no longer updates automatically. It only updates the
calculated cell once I save the file.
 
G

Guest

Hi
First job - go to Tools|Options|Calculation tab and make sure Automatic is
selected.
 
B

bigwheel

snap said:
I have an excel worksheet that use to work fine. Now all of a sudden the cell
with a formula no longer updates automatically. It only updates the
calculated cell once I save the file.
Click to expand...

You may have accidently turned off automatic calculation. Check
Tools>Options>Calculation and see if the Automatic radio button is selected
 
Top