List All External Links in a Workbook
You can list all external links in an Excel workbook by performing a simple search.
Open the search window (Ctrl + F), search for [ in Workbook, and click on Find All to display all external links contained in the cells: