do you have manual calculation selected? (formulas tab/calculation options) try pressing f9...?

i've also seen calc updates fail when there is a circular reference in the workbook... even sometimes when the cell in question is not in any way a part of the circular reference (forumulas tab/error checking)