Absolute reference when linking workbooks

  • Thread starter Thread starter suejay
  • Start date Start date
S

suejay

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
 
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>.
 
Back
Top