Is calculation automatic?
ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"nacholibre" wrote in message ...
| Hello,
|
| I have a formula that uses ISERROR to replace null values with a zero. I
| run and access query to get the data, and paste it into the sheet - and the
| ISERROR has run correctly for years to look for null values and replace them.
| However, recently, this has stopped working. It's as if there is a value in
| the cell that I cannot see. When I double click in the cell, then click out
| of it - it seems to remove whatever value or formatting is there and the
| ISERROR works correctly. Has anyone run into this before? I'd like to
| understand what is happening in these cells, and why simply double clicking
| in and out of them seems to remove the problem.
|
| Thank you,
|
| Nacho