Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is hyperlink staying imbedded when I insert rows into Excel? | Excel Discussion (Misc queries) | |||
Maintain hyperlink when moving excel files | Excel Discussion (Misc queries) | |||
The hyperlink reference doesn't changes when I insert Rows and co. | Excel Worksheet Functions | |||
how to maintain hyperlink in excel to pdf conversion | New Users to Excel | |||
How to maintain hyperlink when sorting data? | Excel Discussion (Misc queries) |