| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with hyperlinks | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| Why won't formulas obey vertical alignment commands? | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
