I have created hyperlinks in a document (separate worksheets). When I add
rows, the hyperlink is not updated, with the result that my hyperlink no
longer points to the correct row. How do I get the hyperlink to update
automatically?

Thank you.

Kind regards,
Douglas