sort excel spreadsheet with hyperlink

[jannkatt]

I have a spreadsheet with hyperlinks in column A. The path in the hyperlink
for each row refers to the contents in column B with a relative reference.
When trying to sort the spreadsheet, if column A is not included in the sort
range, then the hyperlink still works correctly by pointing to the correct
row. However, if column A is included in the sort range, the hyperlink
treats the reference to column B as absolute and points to where the original
cell in column B is located after the sort.

For example, the hyperlink in column A in row 2 refers to the contents in
column B row 2, the hyperlink in column A in row 3 refers to the contents in
column B row 3, etc. When sorting and not including column A, the hyperlink
for row 2 still refers to row 2 in column B. This is what is wanted.

However, if column A is included in the sort, the hyperlink for row 2 points
to row 4808 in column B where the original row 2 contents are located after
the sort. This is not correct.

Is there any way to be able to sort and include column A? There will be
many users accessing this spreadsheet and sorting it. Which means there is a
very good chance the spreadsheet will be messed up.

Thank you.