i have a large workbook with several tabs and many formulas. For some
reason, even though auto-calc is turned on it will not recalc cell formulas
when i change inputs. I have to go to each affected cell, edit the cell and
hit enter to update the value. it is not a problem for =sum formulas, just
those returning a single value from another cell. Anyone experienced this
before?