formulas not updating with data changes

[doby]

Hi!.

I am using Excel 2003 and I am having problems with my formulas.

Probs are as follows:

- My formulas are not updating when I change the data unless I manuall
redo them. I am using the AutoSum key. Nothing fancy here.

- Also, when I try to drag a formula across it just copies the same
formula of the cell I am originating from.

Does anyone have any ideas what is going on here?

Looking forward to any and all help.

Tks in advance.

 

[Kevin H. Stecyk]

doby wrote...

Hi!.

I am using Excel 2003 and I am having problems with my formulas.

Probs are as follows:

- My formulas are not updating when I change the data unless I manuall
redo them. I am using the AutoSum key. Nothing fancy here.

- Also, when I try to drag a formula across it just copies the same
formula of the cell I am originating from.

Does anyone have any ideas what is going on here?

Looking forward to any and all help.

Hi,

I am guessing you need to

Tools | Options | Calculation | Automatic

It is probably set to Manual at the present time?

Hope this helps.

Kevin

 

[doby]

A great big

"THANK YOU".

That did the trick

 

[Kevin H. Stecyk]

Doby,

Glad I could help.

Kevin

Doby wrote,