It is likely that the calculation mode is set to manual, not
automatic. Go to the Tools menu, choose Options, then the
Calculation tab. There, ensure that "Automatic" is checked.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Ozymandias" wrote in
message
...
To be specific:
If I input 5 in cell A1, and input 6 in cell A2, and input
=a1+a2 in
cellA3, the total is 11 for cell A3.
After I do that, let's say I change my input in cell A1 from 5
to 4. The
total in cell A3 should be 10. However, it stays at 11.
I only have this problem on my home computer, but not on my
work computer.
This is driving me crazy, as it makes me lose trust in Excel's
ability to
automatically update totals.