Question about hyperlinks in Excel
 

I have an Excel workbook with numerous rows of data on multiple sheets. I
created a hyperlink in an individual cell in each row to reference a related,
but external Word document (on a network drive). If I choose to sort the rows
(or move to a different sheet), the original address of the hyperlink does
not follow the respective row. In fact, it appears to take on the address of
the previous line item's hyperlink. How can I fix this problem?