id="info"

Question

Locked

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

By 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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Known Issue

by robo_dev In reply to Excel Hyperlinks not foll ...

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.

Collapse -

Reponse To Answer

by John W. In reply to Known Issue

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.

Back to Networks Forum
3 total posts (Page 1 of 1)  

Hardware Forums