This is a "feature" of Excel. The hyperlinks apply to the cells themselves -
not their contents. Therefore, when you sort, the values get sorted but the
links stay put.
Microsoft REALLY needs to fix this. It's annoying, unintuitive, and,
frankly, WRONG behavior.

"lisa needs help" wrote:

I have a column of hyperlinks on my worksheet. When I sort my data, the NAME
of the hyperlink sorts, but not the actual link attached. What can I do?