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

Hi.

I have never had this problem before.

All of a sudden, my excel does not update formulas by itself. I need
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 I
was working on some files I got from a client.

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

Thanks,
Skrepka


--
skrepka
------------------------------------------------------------------------
skrepka's Profile: http://www.excelforum.com/member.php...o&userid=36596
View this thread: http://www.excelforum.com/showthread...hreadid=563383

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

skrepka Wrote:
Hi.

I have never had this problem before.

All of a sudden, my excel does not update formulas by itself. I need
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 I
was working on some files I got from a client.

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

Thanks,
Skrepka

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

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563383

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

Scott,

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

Skrepka


--
skrepka
------------------------------------------------------------------------
skrepka's Profile: http://www.excelforum.com/member.php...o&userid=36596
View this thread: http://www.excelforum.com/showthread...hreadid=563383