Perhaps calc mode is at Manual ? A quick check ..
Click Tools Options Calculation tab
Check "Automatic" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ayprlthing" wrote in message
...
I have a personal finance sheet that has basic formulas which I update
monthly.
However, if I change a data cell, the other cell which has a formula
linked
to it does not pull the new data cell information. The formula is
correct.
The only way to "fix" my problem is to retype the exact same formula and
then
it pulls the new data.
Any advise?
|