Copying linked sheet

[flyfree]

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.

 

[flyfree]

We've worked out that the original worksheet was linked in the same workbook
and was then copied, but trying to copy 'from the copy' caused the problem.
But when we now try to copy and link from the original, we lose the
formatting, even though we tick 'All' and 'Paste Link'

 

[Dave Peterson]

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.