Linked cell displays 0
 

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

Linked cell displays 0
 

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)



AMY Z. wrote:

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

--

Dave Peterson

Linked cell displays 0
 

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

"Dave Peterson" wrote:

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)



AMY Z. wrote:

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

--

Dave Peterson