Linked cell displays 0

A

AMY Z.

Hi,
I copied a cell that contains the value: Apples.
I Special Pasted then clicked Paste Link.
The new linked cell shows the value 0 (zero), not Apples.

I checked the link cell for it's formatting. It is in the "General" mode.

This is actually a report with a lot of links. They all are reporting 0
suddenly. instead of what is really in the original cell. They used to work.

I tried looking in the archives of the newsgroup for this, but maybe I
didn't word it write.
Thank you for your time,
Amy
 
D

Dave Peterson

Try changing calculation to automatic.
tools|options|calculation tab

And if that cell is empty, you can display "" by something like:
=if(sheet1!a1="","",sheet1!a1)
 
A

AMY Z.

Thanks Dave. It worked.
Somebody else was at my computer. I never use the manual calc.
Also thanks for the empty cell formula tip.
Amy
 
Top