Forum Discussion

Rick Wroblewski's avatar
Rick Wroblewski
Copper Contributor
Apr 10, 2018

Updating Internal links

I have created hyperlinks within a page. When I copy the page within the same workbook (excel renames the page) the links take me back to the original page.  I need to update the links so that they keep me on the same page where I am working. Is that called relative links? Is there a method to update all of the links without have to update one at a time?

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Use the Hyperlink function, like so:
    =HYPERLINK("#"&CELL("ADDRESS",Sheet2!A1))

Resources