Formula Problem

[David Leven]

I am using Excel 2000 and I have had one worksheet stop updating
automatically. When changes are made in the worksheet, the only way I can
update the formula is by clicking in the formula's cell. Any ideas what
happened and how I can fix it.

 

[L. Howard Kittle]

Hi David,

I suspect that Calculation is set to Manual.

Tools > Options > Calculation > Automatic > OK

HTH
Regards,
Howard