how do insert rows and maintain the hyperlink in Excel?
 

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?

how do insert rows and maintain the hyperlink in Excel?
 

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.

--
Regards,
Tom Ogilvy


"muraz" wrote in message
...
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?

how do insert rows and maintain the hyperlink in Excel?
 

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.

--

xlsgen - native Excel generator http://xlsgen.arstdesign.com
xlsgen RSS feed : http://www.arstdesign.com/BBS/rssxlsgen.php


"muraz" a écrit dans le message de
...
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?