Maybe you have calculation set to manual.

In xl2003, I'd try:
tools|Options|Calculation tab|make sure it was set to automatic.

Jason Zischke wrote:

Hi All

I have a problem with a workbook doesn't seem to calculate on some cells
until I click into the cell's Formula and exit out then it finally updates.
Is any thing that could be doing that and how can I fix that?

Jason

--

Dave Peterson