Formula Errors

Find Cells with External Links in an Excel Workbook

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Find cells and other workbook elements that refer to external files in Excel.

Find Cells with External Links in an Excel Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to locate external references throughout a workbook, including references not fully identified by Edit Links.
Observed behavior
Excel's Edit Links command identifies external sources but does not always show every cell or formula that uses them.
Before you start

Open the workbook in Excel and note any source names shown under Data > Edit Links or Workbook Links. If you do not know the source name, you can search for an opening square bracket instead.

Solution 1Recommended

Search workbook formulas for external references

Use Find and Replace to list cells whose formulas contain an external workbook name or bracket.

1
Open Find

Go to Home > Find & Select > Find, then select Options to expand the search settings.

2
Set the search scope

Set Within to Workbook and Look in to Formulas. In Find what, enter the external workbook name or an opening square bracket ([).

3
Review matching cells

Select Find All, then select each result to inspect its formula and determine whether it refers to an external workbook.

4
Check hidden sheets

Right-click a worksheet tab and select Unhide if available. Repeat the search and inspect any previously hidden sheets.

Search workbook formulas for external references
Not every bracket is an external link: Table references can also contain square brackets. A formula search may miss links stored outside worksheet cells or referenced through defined names.
Find external references in WPS Spreadsheets

Search for external workbook references in WPS Spreadsheets

Open your workbook in WPS Spreadsheets and search formulas for the source workbook name or an opening square bracket to identify potential external references.

  1. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
  2. 2. Open the search tool: Go to Home > Find and Replace and open the Find tab.
  3. 3. Search formulas: Enter the external workbook name or [ in the search box. Expand the search options and choose formulas and the workbook scope if those options are available.
  4. 4. Inspect the results: Select Find All and review each matching cell's formula. If workbook-wide search is unavailable, repeat the search on each worksheet.
Search formulas for external workbook names or bracketsOpen and edit Microsoft Excel XLSX and XLS filesReview matching cells in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why should I search for an opening square bracket?

Excel formulas that refer to another workbook commonly include its name in brackets, such as [Budget.xlsx]. Search for [ with Look in set to Formulas, but inspect each result because table references also use brackets.

Why does Excel still report a link after I check the formulas?

The reference may be stored in a defined name, chart, conditional formatting rule, data validation rule, query, or connection. Check Formulas > Name Manager and Data > Queries & Connections, along with the relevant chart and rule settings.

Can I search for a specific external workbook?

Yes. In Home > Find & Select > Find, enter the workbook name, set Within to Workbook and Look in to Formulas, then select Find All.

Should I replace every search result that contains a bracket?

No. Inspect each formula first: brackets can indicate table references rather than external links. Change a reference only after confirming what the formula uses and what should replace it.