Mystery Value in my Spreadsheet!

N

nacholibre

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
 
N

Niek Otten

Is calculation automatic?
Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
N

nacholibre

Hello Niek,

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