how do insert rows and maintain the hyperlink in Excel?

[Guest]

I have created an Excel spreadsheet with hyperlinks to worksheets within the
same spreadsheet. However, when I insert rows to here the hyperlink is
linked, the cell does not change to where the link should be connected to.
It stays the same. Any suggestions?

 

[Tom Ogilvy]

If it is in the same workbook, try using the Hyperlink Worksheet Function.
That alone may not be the solution, but should be the foundation.

 

[Stephane Rodriguez]

Use a name.

Simply select the target cell or cell area. Give it a name in the top name
combobox.

Now edit the hyperlink and replace the numerical cell or area reference by
this name, as in "Sheet2!myname".

Your hyperlink now follows row insertions, and other actions.