Open Hyperlinks Navigator
The Hyperlinks Navigator is a task pane (side panel) that lets you see all the hyperlinks in the workbook. The navigator lists the hyperlinks grouped by worksheet. Any links to non-existent files are highlighted in red. Clicking on an item in the navigator will jump to the range containing the link, and show the source, link target, display text, and screen tip, if applicable.
If you switch workbooks, add, or remove any hyperlinks, the Reload Hyperlinks button will refresh the listing.