In Excel for Microsoft 365 on Windows, start at Data > Workbook Links to see links to other workbooks and their source files. If that command is unavailable, search formulas for [, then check defined names, charts, hyperlinks, and data connections because not every external reference appears in one place.
What Excel Means by an External Link
An external link is a reference from the current workbook to information outside it. The most familiar kind is a formula that reads a cell in another Excel file. For example, a formula might refer to cell B2 on the January sheet in a workbook named Budget.xlsx. Excel stores the source workbook and location as part of the reference, and may update the result when the source changes.
People also use “external link” to mean a clickable hyperlink to a website or file, or a connection that imports data from a database or online service. These are related but different things. A workbook-to-workbook formula link, a web hyperlink, and a Power Query connection each have different ways to inspect and manage them. A useful audit therefore starts by deciding which kind of link you are looking for.
Check the Workbook Links Pane First
In current Microsoft 365 desktop Excel for Windows, select Data > Workbook Links. The pane lists linked source workbooks Excel recognizes and provides details or actions for those links. Select a source to inspect its status and available options. Depending on the workbook and Excel update, you may be able to update the source, change it, or break the link from this pane.
This is the quickest first check, but do not treat an empty pane as proof that a workbook has no external references of any kind. The pane focuses on links between workbooks. It is not a complete inventory of web hyperlinks, every data connection, or every possible place where a file path might be stored.
In some Excel versions, the older command is called Data > Edit Links. It may appear only when Excel detects supported workbook links, and its availability and placement can vary by version. If neither command is visible, use the search and inspection methods below. Excel for Mac and Excel for the web can have different layouts or feature availability; when auditing a complex file, use the desktop version and look for the equivalent Workbook Links command on the Data tab.
Search Formulas for Workbook References
A direct formula search is a practical second check. In Excel for Windows, press Ctrl+F, select Options if the extra search settings are hidden, set Within to Workbook and Look in to Formulas, then search for an opening square bracket: [. External workbook formulas commonly include the source filename in square brackets, as in a reference to [Budget.xlsx]. Select Find All to review the matches together.
On Mac, use Command+F to open Find; the available search options and labels may differ slightly. Make sure the search is checking formulas rather than displayed values, and search the whole workbook rather than only the active sheet. A result can be an external reference inside a formula even when the cell displays only a number or text.
This method has limits. Square brackets also appear in some Excel table, or structured, references, so a match is not automatically an external link. Inspect the complete formula and look for a workbook filename and a sheet reference. Conversely, searching for a particular filename can miss links to other sources. Formulas may also use a full file path, such as a folder location, when Excel cannot find the source in the same folder. Review each match instead of deleting text just because it contains brackets.
Inspect Defined Names and Charts
Links can be stored outside ordinary worksheet cells. To inspect defined names, select Formulas > Name Manager. Review the Refers To entries for file names, folder paths, or references to another workbook. Names can be workbook-wide or limited to a particular sheet, and an old name may remain after the cells that originally used it have been cleared. Check whether a name is still used before changing or deleting it; formulas, charts, or other workbook features may depend on it.
Charts can also refer to ranges in another workbook. Select a chart and inspect the formula bar for its series references, or use the chart’s data-selection controls to review the source range. A chart may continue to contain an external series reference even if no visible worksheet formula points to the source. Check charts on hidden sheets too if you are performing a thorough review.
Other less obvious places can include objects or embedded items associated with another file. If the Workbook Links pane and formula search do not explain a prompt or unexpected result, inspect relevant names, charts, and objects rather than assuming that the link is in a visible cell.
Review Hyperlinks Separately
A hyperlink is a clickable destination, not necessarily a formula that pulls data into a cell. It may point to a web address, an email address, a location in the same workbook, or a separate file. A cell can display friendly text such as “Open report” while its actual destination is a long URL or file path.
To inspect one, right-click the linked cell or object and choose Edit Hyperlink (the wording can vary by Excel version). Review the address or destination shown in the dialog before following it. You can also use the context menu to remove a hyperlink when appropriate, but removing the clickable link does not necessarily remove the displayed text. For a large workbook, search may help locate visible URL text, but it cannot reliably reveal every hidden hyperlink destination. Examine links on relevant sheets and objects directly.
Do not confuse a hyperlink to another workbook with a workbook link. Clicking the former opens or navigates to a destination; the latter can make a formula depend on values in a source file. A workbook can contain one kind, both kinds, or neither.
Check Queries and External Data Connections
Data imported from a database, text file, website, or other service is generally managed as an external data connection, not as a cell-to-cell workbook link. In desktop Excel for Windows, open Data > Queries & Connections to review queries and connections available in the workbook. Inspect their properties and source details to understand where data comes from and whether a refresh may contact an external system.
Power Query connections may be listed as queries, while other connection types may appear in the connections area. A PivotTable can also be based on external data. The exact controls depend on how the workbook was built and the connection type. Finding no entries in Workbook Links does not mean there are no external data sources, just as finding a query does not necessarily mean a worksheet formula links to another workbook.
When reviewing a connection, note its source, refresh behavior, and whether the workbook is expected to use it. Do not delete a query or connection merely to silence a warning: reports, PivotTables, or refreshable tables may rely on it. If the source is unfamiliar, confirm its purpose with the workbook owner or your organization’s IT team before refreshing or changing it.
Understand What a Link Is Doing Before Changing It
Once you find a link, decide whether it is intended. A monthly report may deliberately draw totals from a central budget workbook. A copied template may instead contain a stale reference to a former employee’s folder. The same warning can therefore point to a necessary dependency or an abandoned one.
- Update the link when the source is trusted, available, and expected to provide current data. Check that the file and the relevant sheet or range are the correct ones.
- Change the source when the workbook has moved or been replaced. Verify the new source and then check key results, because a different file may have different data or structure.
- Keep the link unchanged when it is an intentional dependency and the source is not currently available. Document the source so another user understands why Excel may ask about it.
- Remove or break a link only when the workbook should no longer depend on that source and you have confirmed the consequences.
Breaking a workbook link is not the same as deleting a formula while preserving its calculation. In common Excel link-management workflows, breaking a link replaces linked formulas with their current values. Those cells then stop updating from the source, and the original formulas may not be recoverable from the workbook. Save a separate copy first and check important totals before and after making the change. Removing a query, connection, name, or hyperlink has different effects, so use the control for the specific item rather than applying “break links” as a general cleanup step.
Common Reasons Links Are Hard to Find
An external reference can outlive the visible content that originally used it. For example, a user might delete a formula cell but leave behind a defined name, a chart series, or a hidden-sheet formula. A workbook copied from a shared folder can also retain a path to the original location. If Excel asks whether to update links when opening a file, the prompt tells you that Excel has detected a dependency; it does not, by itself, establish whether the source is safe or necessary.
Use a methodical check when the source is unclear:
- Save a copy of the workbook before making changes.
- Review Data > Workbook Links or the older Edit Links command if available.
- Search formulas across the workbook for
[and inspect each match. - Review Formulas > Name Manager, charts, and relevant hidden sheets.
- Inspect hyperlinks separately and check Data > Queries & Connections for external data sources.
- After any change, reopen or recalculate the workbook as appropriate and verify important results and refresh behavior.
Keep in mind that a file path found in a formula or connection is evidence of a reference, not proof that the source still exists. Similarly, a workbook may have cached values from an earlier update even while its original source is unavailable. If results matter, compare them with a trusted source rather than assuming a displayed number is current.
Frequently Asked Questions
Where is Workbook Links in Excel?
In Microsoft 365 desktop Excel for Windows, look on the Data tab for Workbook Links. Older versions may show Edit Links instead. If neither command appears, search formulas and inspect names and other link locations.
How can I find an external link when Excel does not list one?
Use Find to search the entire workbook for [ with Look in set to Formulas. Then check Name Manager and chart series. Also inspect hyperlinks and external data connections separately, since they may not appear in the workbook-links list.
Does an external link always mean a link to another Excel file?
No. The phrase can refer to a workbook formula link, a clickable link to a website or file, or an external data connection. These are distinct features and are reviewed in different places.
Will breaking a link delete the formula?
Breaking a workbook link commonly replaces the linked formula with its current value, so the cell no longer updates from the source. Save a backup and verify the result before using the command.
Is it safe to update links when opening a workbook?
Only update a link when you recognize and trust the source and expect the workbook to use its current data. If the source is unfamiliar, do not use the prompt alone as a reason to open or refresh it; check with the file owner or your IT team.
Related
- Excel Color Based on Value with Conditional Formatting
- Excel Custom Number Format: How to Create and Apply It
- How to Select a Sheet in Excel With Keyboard Shortcuts
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Print in Excel on One Full PageTo print an Excel worksheet on one page in Microsoft 365 for Windows, open the Page Layout tab,…
- How to Make a Poster in Word or PowerPoint That Prints WellTo make a poster in Word or PowerPoint, set the page or slide to the finished poster size…
- Excel Accounting Format: Make Negative Values Display in RedTo show negative amounts in red in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1,…
- How to Zoom in Microsoft Excel: Quick Ways to ResizeTo zoom in Microsoft Excel on Windows, use the zoom slider at the bottom-right of the Excel window,…
- Excel Automatic Goal Seek: Options for Repeated ModelsExcel Goal Seek does not automatically rerun whenever a worksheet changes: you must start it again, or use…
- How to Schedule Send an Email in Outlook on the WebTo schedule an email in Outlook on the web, compose your message, open the arrow beside Send, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.