When I change my data, my formulas don't update the answers,why?
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?
|