Some formulas do not update automatically when new inputs are entered
into precedent cells. The auto-calc function is turned on. The
formulas only update when I go to the formula and hit the F2 key. I do
not make any changes, I simply hit the F2 key and then the Enter key -
it is only then that the formula updates correctly based on the new
input in the precedent cell. Why does this happen? Can it be
corrected?


--
Joe A
------------------------------------------------------------------------
Joe A's Profile: http://www.excelforum.com/member.php...o&userid=34751
View this thread: http://www.excelforum.com/showthread...hreadid=545123