When you copy|paste link, you're essentially creating formulas that look like:

=sheet1!a1

This will return 0's if the cell is empty.

You could modify the formula to look like:

=if(sheet1!a1="","",sheet1!a1)

And you'll see cells that look empty.

flyfree wrote:

Worksheet 1 has each cell linked from various cells in another workbook. I
want to copy and link the whole of worksheet 1 into worksheet 2.
When I try to, (Paste special, Paste link), all the cells have 0 in them,
instead of the data.
It may be because when I open spreadsheet 1, it says there is a circular
reference.

--

Dave Peterson