Issues with hyperlinks not moving with sorted text
When I created a hyperlink in excel and sorted the document, the data within the cells moved to accommodate the sorting but the hyperlinks did not. For example, my hyperlink for line 2 stays the same (linking to document 1) even though the in-Excel text linked to the document has changed (with the blue text denoting document 2). How do I edit hyperlinks in Excel so they follow their assigned text when sorted?