When you create a forward link (source to target), XL makes it absolute.
When you create a backward link (target to source), XL makes it relative.

Forward:
Right click in source cell and choose "Copy".
Navigate to, and right click in target cell.
Choose "Paste Special", and click on "Paste Link", then <Esc.

Backward:
Click in target cell and key in = sign.
Navigate to, and click in source cell.
Hit <Enter.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"suejay" wrote in message
...
I notice when a link is created between 2 workbooks, Excel assumes an
absolute reference. Is there a way to set a default to assume a relative
reference when linking workbooks?
Thanks!