Equations are not updating


G

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?
 
Ad

Advertisements

G

garfield-n-odie [MVP]

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

Guest

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

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?
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top