Hyperlinks static but formulas are not. Why?
Hi,
If I set up hyperlink from one cell to a cell in another wksheet (same workbook), then the link doesnt get updated if I change the name of the target wksheet. On the contrary if i write a formula in sheet1 of cell A1 -- =Sheet2!D15 -- then when i change the name of the worksheet Sheet2 to NewSheet2, the formula in sheet1 of cell A1 also gets updated to -- =Newssheet!D15 How is it that formulas get updated on changing name of the wksheet, but hyperlinks dont get updated? -- Thanks a lot, Hari India |
How is it that formulas get updated on changing name of the wksheet, but
hyperlinks dont get updated? I don't know what MS's thinking was on this. As a way to avoid this problem you might consider linking to defined names that refer to cells rather than directly to cell addresses. Defined names will adjust to sheet name changes, as well as to inserting rows, etc. -- Jim Rech Excel MVP "Hari" wrote in message ... | Hi, | | If I set up hyperlink from one cell to a cell in another wksheet (same | workbook), then the link doesnt get updated if I change the name of the | target wksheet. | On the contrary if i write a formula in sheet1 of cell A1 -- =Sheet2!D15 -- | then when i change the name of the worksheet Sheet2 to NewSheet2, the | formula in sheet1 of cell A1 also gets updated to -- =Newssheet!D15 | | How is it that formulas get updated on changing name of the wksheet, but | hyperlinks dont get updated? | -- | Thanks a lot, | Hari | India | | |
Instead of 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) Hari wrote: Hi, If I set up hyperlink from one cell to a cell in another wksheet (same workbook), then the link doesnt get updated if I change the name of the target wksheet. On the contrary if i write a formula in sheet1 of cell A1 -- =Sheet2!D15 -- then when i change the name of the worksheet Sheet2 to NewSheet2, the formula in sheet1 of cell A1 also gets updated to -- =Newssheet!D15 How is it that formulas get updated on changing name of the wksheet, but hyperlinks dont get updated? -- Thanks a lot, Hari India -- Dave Peterson |
All times are GMT +1. The time now is 01:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com