How to Find External Links in Excel and Check Their Sources

To find external workbook links in Excel for Microsoft 365 on Windows, select Data > Workbook Links to review recognized sources, then press Ctrl+F and search for .xl with the search set to the whole workbook and formulas. These checks help you identify cells and other workbook features that refer to files outside the current workbook. Save a copy before changing or breaking any links.

What You’ll Need

The Excel workbook you want to inspect, opened in the Excel desktop app.
Permission to view the workbook and, if possible, access to its linked source files. You can still look for references when a source file is unavailable.
A separate copy of the workbook if you plan to edit links, remove references, or test changes.

Excel uses “external link” to mean more than one thing. This guide focuses mainly on formulas and workbook features that refer to another Excel file, such as [Budget.xlsx]Summary!A1. A clickable website address or file hyperlink is different: it opens a destination when clicked, but it is not necessarily a formula link that Excel can refresh. The distinction matters because the search and repair steps are different.

Step-by-Step

Open the workbook and make a safe working copy. If you only need to identify links, you can inspect the original without changing it. If you may update sources or remove links, use File > Save a Copy or File > Save As and work on the duplicate. Keep the file in a trusted location, and enable editing only if you trust its source. A workbook can contain links to old folders, shared drives, or files you cannot currently reach; you do not need to make those files available just to search for references.
Check the Workbook Links pane first. In Excel for Microsoft 365 on Windows, select Data > Workbook Links. If the workbook has recognized links to other workbooks, the pane lists the source files and provides options for managing them. Select a source to review available actions, such as opening the source or changing its source location. The pane is a useful overview, but do not assume it lists every possible external reference in every feature. If you do not see the command, or the pane is empty, continue with the searches below. Older Excel releases may show Data > Edit Links instead; that older command is not present in every current installation.
Search formulas across the entire workbook. Press Ctrl+F to open Find. In Find what, enter .xl, then select Options if the extra settings are not visible. Set Within to Workbook and Look in to Formulas, then select Find All. This commonly finds references containing workbook extensions such as .xlsx, .xlsm, .xlsb, or .xls. Review the results list: selecting a result takes you to the matching cell, where you can inspect the formula bar and identify the sheet, cell, and referenced file. On Mac, use Command+F; the Find options and labels may vary slightly by Excel release.
Try a bracket search if the first search misses something. External workbook formulas commonly show the source workbook name in square brackets, for example ='C:\Reports\[Budget.xlsx]Summary'!A1. Search for [ with Within set to Workbook and Look in set to Formulas. This can catch references whose filenames do not match the extension search you tried. It can also return unrelated formulas or text containing a bracket, so verify each result in context. Do not replace or delete every bracket just because it appears in a result.
Inspect defined names. Select Formulas > Name Manager. Review the Refers To column for file paths or workbook names in square brackets. Select a name to see its full reference, and note whether its scope is the workbook or an individual sheet. A defined name can point to an external workbook even when no worksheet formula is an obvious match. Name Manager is a separate check: searching worksheet formulas does not guarantee that every name definition has been inspected. If you find a suspicious name, record it and determine which formulas, charts, or rules use it before changing it.
Check charts and linked objects when you need a thorough audit. Select a chart, then select a data series and inspect the formula bar for the series reference. You can also use Chart Design > Select Data to review the chart’s ranges. A series may use a defined name, so check Name Manager if the source is not obvious. For linked pictures or other objects, select the object and inspect the formula bar or its available link settings. This is especially worthwhile when a workbook shows unexpected data but a search of cell formulas finds nothing. The exact controls differ by object type, and not every object exposes its source in the same way.
Review rules that can contain references. To inspect conditional formatting, select Home > Conditional Formatting > Manage Rules, then set Show formatting rules for to the relevant worksheet or the whole workbook where that option is available. Review formulas and any names used by the rules. Also check data validation on cells where the allowed values or behavior seem to come from elsewhere: select the cell and choose Data > Data Validation. Validation lists often refer to a defined name, so trace the name in Name Manager. These checks are useful when a cell behaves as if it is linked but does not contain a visible external formula.
Separate workbook links from hyperlinks and data connections. If you mean clickable links, inspect the relevant cell with a right-click and choose Link or Edit Link, depending on the menu shown; also check shapes or pictures that may have been assigned a hyperlink. These links can lead to websites or files without being workbook formulas. For imported or refreshed data, select Data > Queries & Connections and inspect the query or connection details for a source file, database, or web address. A query connection is not the same as a formula link, so it may not appear in the Workbook Links pane or in a search for .xl.
Record what you find before deciding what to do. Note the sheet and cell or object, the source file or path, and whether the reference appears in a formula, name, chart, rule, hyperlink, or query. If the source is still needed, locate it and confirm that it is the correct file before updating anything. If you think a link is obsolete, test changes in your copy and check key results afterward. Removing a link can replace formulas with fixed values or stop a chart or report from updating, so identification should come before cleanup.

Common Mistakes

Searching only the active sheet. The Find dialog can be limited to the current sheet. Set Within to Workbook or you may overlook references elsewhere. Also check that Look in is set to Formulas; searching displayed values is not the same as searching the underlying formulas.

Assuming an empty Workbook Links pane proves there are no external references. The pane is a useful list of recognized workbook sources, not a substitute for checking names, charts, rules, connections, and hyperlinks when you need a complete picture. Use multiple checks that match the kind of link you are investigating.

Treating every clickable link as a workbook formula link. A cell can contain a hyperlink to a website while its value is plain text. That is different from a formula that retrieves data from another workbook. Decide whether you are looking for an external workbook reference, a clickable destination, or an imported data source before choosing the inspection method.

Breaking links as a first response. Breaking a workbook link can replace formulas that depend on the source with their current values. The results may stop updating, and the change may be difficult to reverse after saving. Confirm the link is no longer needed and keep a backup before using a removal option.

Trusting search results without checking context. A filename or bracket can appear in ordinary text, notes, or formulas that do not represent the problem you are investigating. Open each result, inspect the formula bar, and trace any defined names before making edits.

Tips

Search for both .xl and [. The first targets common Excel file extensions; the second can reveal workbook references with less predictable names.
Use Find All rather than repeatedly selecting Find Next when you need a review list. Keep the results visible while you record the matching sheets and cells.
When a formula contains a full path, check whether it points to a local folder, a mapped drive, or a network location. A different computer may not use the same drive letter or folder structure.
If a source is unavailable, write down the exact filename and path shown in the formula or link pane. That information can help you ask the workbook owner for the right file rather than guessing.
For a recurring audit, keep a short checklist of the areas you reviewed: formulas, defined names, charts and objects, rules, hyperlinks, and queries or connections. This makes it clearer what “no links found” actually means.
Excel for the web has fewer inspection and link-management controls than the Windows desktop app. If the needed Find options or Workbook Links controls are missing, open the workbook in desktop Excel. On Mac, use Command+F instead of Ctrl+F, and look for the corresponding Data commands available in that Excel release.

Troubleshooting

Find returns no results, but Excel still reports a link. Confirm that Within is set to Workbook and Look in is set to Formulas. Search for both .xl and [, then inspect Name Manager and chart series. The reported link may be stored in a name or another feature rather than a regular cell formula.

The Workbook Links command is missing. Check that you are using the desktop app and that the workbook is open in an editable Excel format. Some releases show Edit Links rather than Workbook Links, and some interface differences depend on the update channel or platform. If neither command is available, use Find and the manual checks in this guide. Excel for the web may not expose the same controls as Excel for Windows.

A source appears, but the file cannot be opened or updated. The source may have been moved, renamed, deleted, or stored somewhere you cannot access. Copy its displayed path and ask the file owner or your IT team to confirm the current location. Do not point the link at a similarly named file until you have verified that it contains the intended data.

You find a hyperlink but not an external workbook reference. Inspect the cell or object’s link settings to see its destination. A hyperlink usually opens a location; it does not by itself mean that a formula is importing values. If you are looking for data that refreshes, check formulas, Workbook Links, and Queries & Connections separately.

Results seem to change after you edit a link. Stop and reopen your untouched backup if possible. Compare formulas and key outputs with the original, and confirm that you changed the intended source rather than merely updating a path. If the change was saved over the original, undo may not restore every downstream effect; avoid further edits until you can compare against a clean copy.

Frequently Asked Questions

How do I find external links in Excel quickly?
In Excel for Windows, check Data > Workbook Links, then press Ctrl+F, search for .xl, and set the search scope to the whole workbook and formulas. Search for [ as a second check.

Can Excel find every external link in one search?
No single search is guaranteed to find every kind. Formula searches can locate many worksheet references, but names, charts, hyperlinks, rules, and data connections may need separate inspection.

How can I tell whether a link points to another workbook?
Look for a workbook filename in square brackets in a formula or name, such as [Sales.xlsx], or inspect the source shown in the Workbook Links pane. A web address assigned as a hyperlink is a different kind of link.

Why does my workbook say it has links when I cannot see any?
The reference may be in a defined name, chart series, linked object, or another feature rather than an obvious cell formula. Check those areas and look for old file paths as well as current ones.

Can I remove an external link without changing the workbook’s results?
Not always. Breaking a formula link can replace a formula with its current value, so the result will no longer update from the source. Test in a copy and confirm the impact on dependent formulas, charts, and reports before saving.

Does this method find links to websites?
The formula search is aimed at workbook references, not every clickable website address. To inspect web hyperlinks, select the linked cell or object and review its link settings. For web data that refreshes, inspect queries and connections too.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.