Links between workbooks always go Absolute.

Links within a workbook go Relative.

I have never seen a method or option that would change this default behaviour.

I don't guess that was much help<g>

Gord Dibben  MS Excel MVP

Hi Joanne,

First, what kind of links are we talking about, formulas or hyperlinks?

Second, it is not true that all links within a workbook are relative (here
I'm referring to formulas), it depends on how you do them:

1. If you type = and then click on another sheet and click a cell - the link
is relative.
2. If you select a cell you want to link to and do Copy, move to a new
location within the workbook and choose Edit, Paste Special, Paste Links -
the link is absolute, even if its in the same sheet.
3. If you reference a range name, for example =Budget - the reference is
almost always absolute.
4. When you are creating links between workbooks using all the methods
described above the links default to absolute, except if the range name has
been defined as relative, something that is very rarely done.  However, if
you type = and click in another workbook and on a cell, if you press F4 one
or more times before you press Enter, you can convert the reference to
relative.  Of course you can always do that after you enter the formula by
selecting it (the formula, not the cell) and pressing F4 as many times as
necessary.

Finally, you can convert absolute references $A$5 to relative for one or
more cells by using Find & Replace.  Press Ctrl+H, and enter $ in the find
what box and nothing in the replace with box.

Cheers,
Shane