Paste link

[Erin Leva]

I currently have Excel 2003 and I am attempting to paste link. The cell I'm
copying is blank but when I paste link the cell I paste on comes up 0. This
is screwing up my figures as these are all for formulas. How can I paste
link and have the cell be blank as well. Thank you for your help in advance.

 

[Ron de Bruin]

Hi erin

Tools>Options

On the View tab you can turn of "zeros values"

 

[sb1920alk]

Let's say that the Paste Link formula is =Sheet1!$A$1 which is calculating to
0 because A1 on Sheet 1 is blank. Replace =Sheet1!$A$1 with
=IF(Sheet1!$A$1="","",Sheet1!$A$1)