Try rebuilding the dependency-tree with CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten

"Curt" wrote in message
...
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?