I am trying to copy a worksheet in its entirity into a new workbook. I would
like the two worksheets to be linked so that when the source worksheet is
updated, this feeds through to the destination document. I know this is
possible through right clicking over the worksheet tab and copying into a new
work book. It is possible on my computer at home and at my previous empolyers
and friends I have discussed it with have also confirmed this.

I have moved into a new job where the version of Excel is 2003 however the
method I have explained above does not result in the same outcome. The values
are returned but the links are not present unless one types in '='[table
a.xls]Sheet1'!$A$4'. If the cell is empty the value '0' is returned. I know
through the options tool bar this is rectifiable, however it is a much less
straightforward route, particularly when I know it is possible through
copying a worksheet. This obviously saves copying forumlas, formats and
switching off zero values.

No-one in the organisation seems to be able to help, including IT!