Hi, I have an Excel file that has many hyperlinks linking to cells on other
sheets all within the same file. I created the hyperlinks by using defined
ranges and then going to Insert, Hyperlink, and choosing the item from the
"Defined Names" list.

This works great until the data is sorted. Then the hyperlinks point to the
cell where the item was originally instead of to the new location.

It's interesting because inserting and deleting rows doesn't seem to matter.
It's only when the data is sorted. Is there a macro or anything that would
update the hyperlinks and make them point to their new location?

Thanks in advance for any information.