How to find external links in excel workbook

Select your chart and go to the Format tab that appears once youвЂ™ve done so. If youвЂ™re using Microsoft Excel to place your data in a handy chart and youвЂ™re pulling in more data from another workbook, itвЂ™s pretty easy to find those links. If necessary, you can also select one to see the entire workbook name in the Refers To box at the bottom of the window. Since these have the XLS or XLSX extension, you should be able to spot them easily. When the Name Manager window displays, you can look for workbooks in the Refers To column. Go to the Formulas tab and click вЂњName Manager.вЂќ Then, just look for those workbook links. Use Cell Relationship Diagram to find all external links and broken links in workbook Excel 2013 introduces a new add-in to view the relationship diagram. While a find-and-select dialog box for your search, like with formulas, isnвЂ™t currently an option, you can pull up all defined names in your workbook. As you know, labeling a cell or range with a meaningful name, especially if it contains a reference link, is convenient. Find Workbook Links in Defined NamesДЄnother common location to have external references in Excel are cells with defined names. Just choose one of those options instead of Formulas in the вЂњLook InвЂќ drop-down list. If you make any changes in the source workbook, the calculations will keep changing. There is a chance to lose or delete the external workbook there has a chance to affect the current workbook data or calculations.

Tip: You can use the Find dialog box to find workbook links in values, notes, and comments, too. In a large calculation, you may repeatedly use different sourcebooks as a reference.

You can click that column header to sort alphabetically if you have more than one workbook linked. You should see your linked workbooks display under Book.

How to find external links in excel workbook