Questions

Excel Hyperlinks not following the sort. How can I fix this?

+
0 Votes
Locked

Excel Hyperlinks not following the sort. How can I fix this?

John W.
I have a spreadsheet of servers & their associated databases. When I click on a database there is a hyperlink that takes me to another worksheet with more information on that particular server & database. Plus I also have a "Sort by Server" & a "Sort by Database name" button. These buttons run macros that highlight the spreadsheet & do a sort by the corresponding cell row. Those buttons work great. But when I run the sort, the hyperlink doesn't follow the value it's linked too.
For example...The word "Names" in cell A23 is hyperlinked to worksheet #3. That works fine. But if I resort by database name or server (or whatever the opposite is at that time), it changes the value but the hyperlink doesn't follow the new sort. "Names" may be in B17 now. But the hyperlink in A23 is still linked to "Names" and perhaps should be now, "City" going to worksheet #6.
Is there a way to make the hyperlink follow the sort?

Hope this makes sense. Thank you for your time.

John
  • +
    0 Votes
    robo_dev

    Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel
    http (colon slash slash) support (dot) microsoft (dot) com (slash)kb (slash)214328

    I think hyperlink sorting only works if they are part of a named range.

    +
    0 Votes
    John W.

    Thank you. I found it as well after continually digging. I'm trying to select your reply as the answer but it won't let me. Thank you for your time.

  • +
    0 Votes
    robo_dev

    Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel
    http (colon slash slash) support (dot) microsoft (dot) com (slash)kb (slash)214328

    I think hyperlink sorting only works if they are part of a named range.

    +
    0 Votes
    John W.

    Thank you. I found it as well after continually digging. I'm trying to select your reply as the answer but it won't let me. Thank you for your time.