Mystery Value in my Spreadsheet!
 

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

Mystery Value in my Spreadsheet!
 

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

Mystery Value in my Spreadsheet!
 

Hello Niek,

Yes, calculation is on automatic. Have you experienced this issue before? :)

"Niek Otten" wrote:

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