How do I create relative hyperliks inside Excellworkbook ? Sweden
 

Hi ("Hej" in Swedish)

When inserting hyperlink on sheet1 to sheet3 A5 and then adding a new row
above A5 at sheet3 the link stays at A5, but I want it to "follow" orgin cell
A5 (now cell A6).

Anyone out there....?

Instead of using Insert|hyperlink, maybe you could use the =hyperlink()
worksheet function:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)


If you really want to stick with the Insert|hyperlink version, you could give
your target cell a nice range name (Insert|Name|define), then use that when you
create the hyperlink.

Crop Protection wrote:

Hi ("Hej" in Swedish)

When inserting hyperlink on sheet1 to sheet3 A5 and then adding a new row
above A5 at sheet3 the link stays at A5, but I want it to "follow" orgin cell
A5 (now cell A6).

Anyone out there....?

--

Dave Peterson