You need that reference or else Excel won't know where to link to.

There is one option you could use, which is to copy the tab from the
external sheet into your current one. To do that, make sure both worksheets
are open, go to the workbook with the tab you want to copy, right click on
it, and select "Move or Copy". Then, choose the worksheet you want to copy
the tab to and make sure "Create a Copy" is selected.

Hope that helps
--
Regards,

David Billigmeier



"ChrisK" wrote:

Everytime I link an cell to another workbook, it automatically puts in an
absolute reference. Is there a setting I can change so I do not have absolute
references appear. This does not happen when you link a cell within the same
sheet only external worksheets.

Thanks