updating formulas
 

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?

updating formulas
 

Tools/ Options/ Calculation:
set to Automatic.
--
David Biddulph

"Charlotte" wrote in message
...
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?

updating formulas
 

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

"Charlotte" wrote:

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?

updating formulas
 

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

"David Biddulph" wrote:

Tools/ Options/ Calculation:
set to Automatic.
--
David Biddulph

"Charlotte" wrote in message
...
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?

updating formulas
 

I got it thanks so much

"David Biddulph" wrote:

Tools/ Options/ Calculation:
set to Automatic.
--
David Biddulph

"Charlotte" wrote in message
...
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?