Zeros in Linking

[BrianK]

In my current worksheet I have created links to a second
worksheet in the same file. I notice that Excel throws
the value of zero in my current worksheet even through
there is no zero in the other worksheet. In other words,
whether there is a null or 0, I am seeing a 0 in my
current worksheet. Is there a way to eliminate this?

 

[Paul]

In my current worksheet I have created links to a second
worksheet in the same file. I notice that Excel throws
the value of zero in my current worksheet even through
there is no zero in the other worksheet. In other words,
whether there is a null or 0, I am seeing a 0 in my
current worksheet. Is there a way to eliminate this?

Tools > Options > View tab
Uncheck "Zero Values".

 

[BrianK]

Ideally I want Excel to show a null value when linked to
an empty cell. However, it shows a zero. This is not
what I want so unchecking zero values may not solve my
problem. Is there a way for Excel to link to an empty
cell and show a null value?

 

[Peo Sjoblom]

Only by formatting like in General;General;
or uncheck zero values under tools>options>view, of course then real zeros
won't be shown,
otherwise you can wrap the link in an IF function

=IF(Sheet1!A1="","",Sheet1A1)