Forum Discussion
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?
- Use the Hyperlink function, like so:
=HYPERLINK("#"&CELL("ADDRESS",Sheet2!A1))
