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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"TJ" wrote in message
...
I have an extensive workbook that does not always calculate when I hit F9.
I
often have to enter each cell by hitting F2, theb Ctrl+Shft+Entr in order
for
cell to calculate. This is very cumbersome when there are thousands of
cells
that contain formulas.