Question Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by 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.

by 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.

This discussion is closed to new replies.