Cell Values do not recalculate unless you press f9

[John.Dand]

Hi,

When using excel 2003 i have cells where the value is calculated by a
formula, if i change one the others used to update fine but no will
only update if i press F9.

Any ideas what is causing and how to resolve?

Thanks

John

 

[ChrisM]

In message (e-mail address removed),

Hi,

When using excel 2003 i have cells where the value is calculated by a
formula, if i change one the others used to update fine but no will
only update if i press F9.

Any ideas what is causing and how to resolve?

Thanks

John

Have you inadvertantly set calculation to Manual?
In Excel 2000:

Tools -> Options -> 'Calculation' Tab...