updating formulas

[Guest]

I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?

 

[David Biddulph]

Tools/ Options/ Calculation:
set to Automatic.

 

[Guest]

Goto Tools|Options|Calculation
Make sure Automatic is selected and not manual

 

[Guest]

Ok, thanks, so how do you set to automatic? I am not sure about this. Thanks

 

[Guest]

I got it thanks so much

Tools/ Options/ Calculation:
set to Automatic.