Paste link

E

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.
 
S

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unlink cells- how? 0
paste link break down 1
"0" in pasted link 1
using 'paste link' into seperate tab 4
Can I put hyperlink to an email in a cell? 1
Excel Data pastes into 2 cells not 1 1
I want Paste Special (not Paste Link) 2
Linking problems in Excel 2007 2

Top