When chenging one of the formula inputs, the result is not updated. Why?

S

skrepka

Hi.

I have never had this problem before.

All of a sudden, my excel does not update formulas by itself. I nee
to press F9 every time I change a formula input for get a new result.
This happedned two days ago on both my laptop and my desktop after
was working on some files I got from a client.

What whould be the reason for this, and how do I fix.

Thanks,
Skrepk
 
M

Maistrye

skrepka said:
Hi.

I have never had this problem before.

All of a sudden, my excel does not update formulas by itself. I nee
to press F9 every time I change a formula input for get a new result.
This happedned two days ago on both my laptop and my desktop after
was working on some files I got from a client.

What whould be the reason for this, and how do I fix.

Thanks,
Skrepka
Click to expand...

Check Tools -> Options....
Goto the Calculation tab.
Make sure "Automatic" is selected and hit OK.

Scot
 
S

skrepka

Scott,

thank you very much. I guess this was an easy fix, but I would hav
never known about it. Now its working perfect.

Skrepk
 
Top