Equations are not updating

[Guest]

I think the latest Windows Update messed up my spreadsheets ability to update
it's equations. Let me create a scenario to depict my problem. I creat a
simple equation A1 + B1 and place the answer in C1. If the value of A1=2 and
the Value of B1=2 then C1=4. If I cange the value of A1 to A1=4 then the
value of C1 should automatically change to 6 but it won't. In order to get
the equation to update I have to left mouse click on cell C1 and then place
my cursor in the eqution on the function line. Then I need to hit the
"Return" key for the equation to update. Shouldn't it be updating
automatically? Does anyone know how I can fix this problem?

 

[garfield-n-odie [MVP]]

In Excel, click on Tools | Options | Calculation | Automatic | OK.

 

[Guest]

An easy fix:
pull-down:
Tools > Options > Calculation and check Automatic

 

[Guest]

I have the same problem. I find random cells not responding to the formula
in which they are inciuded. I have already checked that my calculations are
on automatic. There doesn't seem to be a pattern to the problem.

I don't know if it is due to the update. Maybe?

 

[Guest]

If you have auto re-calculation on and are still having a problem look for
the post "Links Not Updating" first posted on 9-19-2005. I recently received
more infomation on this.

Jerry