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!

If you click on the formula in the formula bar and position the cursor
in a cell reference, you can then press F4 repeatedly to cycle between
absolute and relative addresses.

If you want to get rid of all the $ symbols completely, then highlight
the cells, do CTRL-H and use Find/Replace to find $ and replace with
nothing.

Hope this helps.

Pete

On Mar 29, 10:26*pm, suejay wrote:
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!

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!