To find links to other workbooks in Excel, check the Data tab’s Workbook Links command, then search formulas for an opening square bracket, [. Also inspect defined names and charts if you need a thorough check: some external references are not ordinary cell formulas. These steps apply to Excel for Microsoft 365 on Windows.
What You’ll Need
- The workbook you want to inspect. If possible, save a copy first, especially if you may change or remove links.
- Excel for Microsoft 365 on Windows for the ribbon paths below. The names and locations of link-management commands can differ in older Excel versions, on Mac, and in Excel for the web.
- If you know the source workbook’s name, have it handy. Searching for that name can make it easier to distinguish the link you want from other references.
Step-by-Step
- Save a working copy and open the workbook. Use File > Save As to make a separate copy if you are only investigating, or if you might edit formulas or break links. If Excel displays a security warning about external content, do not enable it just to locate references. You can inspect links without refreshing them. If a workbook is read-only, save a copy before attempting changes.
- Check Excel’s Workbook Links list. Select the Data tab and look for Workbook Links. In some Microsoft 365 layouts, the command is grouped with Queries & Connections; the exact placement can vary with the ribbon layout and window width. Open it to see the external workbooks Excel has identified. Depending on the workbook and Excel build, the pane can show source names and offer actions such as refreshing or changing a source. This is a useful starting point, but it is not a guarantee that every kind of external reference is listed there.
- Note the listed source names before investigating further. A source may appear as a file name, a path, or a path that is no longer available. Record the displayed name and any status information. Do not choose Break Links as a way to investigate: it replaces linked formulas with their current values and can be difficult to reverse. If you cannot see Workbook Links, continue with the formula search and check whether your Excel version uses an older Edit Links command under Data.
- Search formulas across the whole workbook. Press Ctrl+F to open Find. Select Options if the extra settings are hidden. Set Within to Workbook and Look in to Formulas, then enter an opening square bracket, [. Select Find All. External workbook formulas commonly contain a workbook name in square brackets, such as [Budget.xlsx]. Using the bracket is a broad way to surface references even when you do not know the source file’s name. If you do know it, search for that file name as well.
- Review each search result rather than assuming every match is a link. In the Find All results, select a result to go to its cell, then inspect the formula bar. A typical external reference includes a workbook name, a sheet name, and a cell reference. For example, assume you enter a formula in Summary!C2 in the current workbook, the source workbook Budget.xlsx is open, and its January!B6 contains 1,250. The formula
='[Budget.xlsx]January'!B6returns 1,250. If the source workbook is closed, Excel may display a longer reference containing its folder path. A square bracket can also occur in structured table references, so check the surrounding formula and the file name before calling a match an external workbook link. - Check defined names. Press Ctrl+F3 to open Name Manager and review the Refers To column. Names can point to cells in another workbook even when the related formula is not easy to spot on a worksheet. Look for a bracketed workbook name or an old folder path. Check both workbook-scoped and sheet-scoped names when available. If you find a name you do not recognize, note its name and destination before editing it; charts, formulas, or other workbook features may depend on it.
- Inspect charts and other objects if you need a complete audit. A chart series can refer to an external workbook even if a worksheet formula search does not find it. Select a chart, choose a series, and inspect the formula bar for its series reference. Check charts on hidden sheets too, after making a copy and unhiding sheets if you are authorized to do so. PivotTables, queries, and connections may also use external files or data sources. On the Data tab, open Queries & Connections to review queries and connections, but remember that an outside data connection is not necessarily a workbook-to-workbook formula link.
- Separate workbook references from clickable hyperlinks. A cell can contain a clickable link to another Excel file without using a formula that calculates from that file. Select the cell and inspect the link using its context menu or Ctrl+K, where available. Treat this as a separate check from Workbook Links and the formula search. If you are checking every route to another file, also inspect shapes or text boxes that may have hyperlinks.
- Make a record before taking action. Write down the worksheet and cell, defined name, chart, or connection that contains each reference, along with the source file and path if shown. Then decide whether you only need to locate the link, update its source, or remove it. For a source change, confirm that the replacement workbook contains the expected sheet and cells. Save and verify the result after any change; do not remove or refresh links until you understand what uses them.
Common Mistakes
- Searching only the active sheet. Find normally starts with the current sheet. Set Within to Workbook so Excel searches other worksheets too. Hidden or protected content may require additional steps or permission to inspect.
- Looking in values instead of formulas. A formula can display a number or date without showing its source in the cell. Set Look in to Formulas so the search checks the formula text, not just the displayed result.
- Treating every bracket as an external link. Excel table formulas often use square brackets to refer to column names. Confirm that the match includes a workbook name or path, not merely a table reference.
- Assuming Workbook Links is an exhaustive inventory. It is a useful overview, but defined names, chart series, hyperlinks, and data connections need separate consideration. The kind of reference matters when deciding where to look.
- Breaking a link before checking its impact. Breaking a workbook link can replace formulas with fixed values. That may stop updates and remove the calculation logic. Make a backup and check with the workbook owner before doing it.
Tips
- Search by the source file name when you know it. A specific name such as Budget.xlsx is easier to review than a broad search for [. If the source might have been renamed, search a distinctive part of its old name or path too.
- Use Find All as an index. Keep the results window open while reviewing matches, and note the sheet and cell for each relevant result. This is faster than jumping between sheets without a record.
- Check a link’s purpose before updating it. Some workbooks intentionally pull data from a shared report or archived file. Confirm that the replacement source is correct and accessible to the people who use the workbook.
- Distinguish formulas from connections. A Power Query or other data connection can retrieve information from a file without creating a normal external-reference formula. Use Queries & Connections to investigate those sources separately.
- Consider your Excel version. On Mac, ribbon labels and link-management options may differ; use the formula search and Name Manager as alternatives if Workbook Links is not available where expected. Excel for the web has fewer inspection and management options, so open a copy in the desktop app for a detailed audit.
Troubleshooting
- Workbook Links is missing. Maximize Excel or check the Data tab for a collapsed group or overflow menu. If it still is not there, search the ribbon for Workbook Links, check for an older Edit Links command, and use Find All and Name Manager. The command may not be available in every version or workbook situation.
- Find returns no matches, but you suspect a link. Confirm that Within is set to Workbook and Look in is set to Formulas. Search for a known source name as well as [. Then inspect Name Manager and chart series. A link may be in an object or connection rather than in a cell formula.
- Find returns too many results. Review each formula for a workbook file name or path. Table references can contain brackets too. Narrow the search using a distinctive source name, and avoid changing formulas just because they appeared in the results.
- Excel asks to update links or cannot find the source. The source may have moved, been renamed, or be unavailable on your computer. Use the displayed source information to locate the correct file, and confirm it with the workbook owner before changing anything. If you do not want to refresh while investigating, decline the update prompt; the workbook may show saved values that are out of date.
- You cannot inspect a worksheet or object. A sheet may be hidden or protected, or the workbook may be restricted. Ask the owner for access rather than trying to bypass protection. If you are authorized, work on a copy and check hidden sheets and their charts as part of the audit.
Frequently Asked Questions
How can I find all external links in an Excel workbook?
Start with Data > Workbook Links, then search Within: Workbook and Look in: Formulas for [. Review Name Manager and chart series too. No single check is certain to cover every type of reference.
What does a square bracket mean in an Excel formula?
In an external workbook reference, brackets commonly enclose the source workbook name, such as [Budget.xlsx]. Brackets also appear in structured references to Excel table columns, so inspect the whole formula.
Can I find links to another workbook if it is closed?
Usually. The formula may show the workbook name and a folder path even when the source is closed. If the file has moved, Excel may still show the old reference, but it cannot retrieve current data from an unavailable source.
Are hyperlinks the same as workbook links?
No. A hyperlink opens a location or file when clicked; an external workbook formula retrieves or calculates with data from another workbook. Check hyperlinks separately if you are looking for every clickable route to another file.
Does breaking a link delete the source workbook?
No. It does not delete the source file, but it can replace linked formulas in the current workbook with their current values. That removes the formulas’ ability to update from the source, so save a copy first.
Can I do this in Excel for the web or on Mac?
You can search formulas in many versions, but menu names and link-management features vary. For a thorough check, use the desktop version where possible; on Mac, use the Data tab if its link command is available, plus Find and Name Manager.
Related
- How to Email an Excel File That’s Too Large Safely
- Excel Audit Tools: How to Enable and Use Them
- How to Enable an Audit Trail in Excel: Track Changes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets COUNTIF by Cell Color: What Actually WorksNo—Google Sheets’ COUNTIF function cannot count cells by their fill color. It checks cell values against a criterion,…
- How to Make a Subtotal Row in Excel with Grouped TotalsTo make subtotal rows in Excel, sort your data by the column you want to group, select a…
- Can You Custom Freeze Panes in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, select the cell immediately below the rows and to the…
- Share Your Outlook Calendar: Steps and PermissionsTo share an Outlook calendar, open Calendar, choose Share Calendar, select the calendar, enter the person’s email address,…
- Excel Power Query: Enable Background RefreshTo enable background refresh in Excel for Microsoft 365 on Windows, open Data > Queries & Connections, right-click…
- Excel Consolidate Rows and Sum Data: A Practical GuideYes. To combine repeated labels and add their values in Excel, create a PivotTable and put the label…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.