I have formulas in certain cells which should change(or update) as the data it is referenced to changes. But this does not happen. My "Calculation Options" on the formulas tab is set on automatic. Even after i save my new information the formulas do not update. Once i re-enter the formula, only then does the formula update and show the correct result.

Please help.


Thanks

Chad