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
- Follow via:
- RSS
- Email Alert
Question
Answers (1)
0
Votes
Known Issue
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.
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.
18th Jan 2012
Replies
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.
John W.
18th Jan 2012
