Cell Values do not recalculate unless you press f9

J

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
 
C

ChrisM

In message [email protected],
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
Click to expand...

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

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