thanks...do i need to do that for each tab or just once for the whole file?
what causes that problem in the first place? thanks!!!

"Niek Otten" wrote:

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?