You can go to ToolsOptionsView and uncheck "zero values"

Or write a formula rather than use the "paste link"

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


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 05:38:02 -0700, Khartoum
wrote:

I have tried using the skip blanks option but this then disables the paste
link option. Confused!

"Khartoum" wrote:

When i paste link i get zeros in all empty cells. Can i prevent this?
Anybody?