zero value when copying cells between worksheets

[joe]

i have a problem copying cells between worksheets in the same workbook. most
of the cells copy and are linked OK but the 2 final columns in the worksheet
table copy and show a zero value. in the formula bar it shows that the cell
is copying the correct data. if you copy the data from a cell that is working
within the same worksheet it just copies the total from the cell and then
when you F2 the cell it shows a xero value. this is difficult to explain but
it seems that most of the worksheet is working OK but the end 2 columns are
acting quite differently.

 

[Dave Peterson]

It sounds like you're using Edit|copy, edit|paste special|paste link.

If that's the case, instead of using formulas like:

=sheet2!a1

use a formula like:
=if(sheet2!a1="","",sheet2!a1)