How to Find External Links in Microsoft Excel Workbooks
Finding links and external references in a Microsoft Excel workbook isn’t as easy as you’d expect. To find all workbook links, you’ll need to search in the formulas, defined names, objects, chart titles, and chart data series. In this tutorial, we’ll explain how to find external links in Excel quickly and easily. How to Find External Links in Excel Cells The first way to find external links is by searching within cell formulas. To do so, you need to use the Excel Find feature: Open your Excel worksheet and press Ctrl + F to open the Find and Replace dialog box. Select Options . In the Find what box, type “.xl” to capture all Excel file extensions. Under Within , select Workbook . Under Look in , choose Formulas . Select Find All . The Find and Replace window will display a list of all external links found within formulas inside your workbook. Note: If you’ve linked your spreadsheet to an external workbook, the link name will display the workbook’s filename along w...