HullsparkCan't find the external links in an Excel workbook? Where they hide, and how to look
Every time you open the file, Excel warns that the workbook contains links to external sources. Workbook Links (Edit Links in older versions) lists the files they point to, but not where in the workbook the links sit. You clicked Break Link and the warning is still there. This page walks through the places links hide, in the order worth checking.
Hullspark · updated 2026-10-22
Short answer
Microsoft's own article lists the places a workbook link can sit: formulas, defined names, objects such as text boxes or shapes, chart titles and chart data series, and says there is no automatic way to find all of them＊1. In Microsoft 365 the Workbook Links pane has a Find next command that jumps to a location using the selected workbook, but Microsoft does not say which places it covers＊3. Work through the table below, top to bottom.
Menu names differ between Excel versions. This page follows Microsoft 365 and gives older names in brackets. If you do not see one, look for the nearest wording on the ribbon.
Where external links hide, and how to get there in Excel
| Place | How to look | What to look for |
|---|---|---|
| Cell formulas | Ctrl+F > Options > Within: Workbook, Look in: Formulas, search for .xl, Find All＊1 | A file name in square brackets, like [Book1.xlsx]Sheet1!A1＊5 |
| Defined names | Formulas > Name Manager, read the Refers To column＊1 | A name that points to a bracketed file name. Hidden names do not appear in this list |
| Conditional formatting | Home > Conditional Formatting > Manage Rules, show formatting rules for This Worksheet. Repeat per sheet | Rules copied in from another workbook |
| Data validation | Home > Find & Select > Go To Special > Data validation selects the cells. Then Data > Data Validation and read the Source box | A list whose source is in another workbook |
| Charts | Select the chart, Chart Design (older: Design) > Select Data, check each series. For a title, click it and read the formula bar＊1 | A SERIES formula that names another workbook |
| Shapes, form controls, text boxes | Ctrl+G (or F5) > Special > Objects > OK, then press Tab to move between them and read the formula bar＊1 | A text box or control linked to a cell in another file |
| PivotTables | Select the PivotTable, PivotTable Analyze (older: Analyze) > Change Data Source | A source in another workbook |
| Data connections and queries | Data > Queries & Connections, right-click the connection > Properties | A query parameter can use data from another workbook＊1 |
| Table formulas, sparklines | Select a cell in the table column and read the formula bar. For sparklines select the cell, Sparkline > Edit Data | Easy to miss |
| Hidden sheets | Right-click a sheet tab > Unhide. A sheet set to "very hidden" with VBA is not in that list and can only be shown from the VBA editor (Alt+F11) | Everything above applies on hidden sheets too |
| Links nothing uses | Listed in Workbook Links (Edit Links), but none of the places above holds it | Microsoft says older versions of Excel hid links in unused names. Breaking that workbook's link in the Workbook Links pane removes them＊1 |
Hyperlinks (the clickable kind that open a file or web page) look similar but are not what triggers the prompt to update links. Treat them separately from formula references.
What order to check, on a copy first
- Save a copy of the file first. Break Link replaces formulas with their current values, and in desktop Excel it cannot be undone＊2. Keep the original.
- Open Data > Queries & Connections > Workbook Links (older: Data > Edit Links) and note each source workbook. In Microsoft 365, select a workbook and choose Find next to jump to where it is used＊3.
- Search the formulas for
.xl(first row of the table). - Then Name Manager, conditional formatting, data validation, charts, shapes. Fix each reference you find, then save.
- After each fix, save, close, reopen and see whether the warning is gone.
Community answers also mention renaming the file to .zip and removing the externalLinks parts by hand＊4. That can corrupt the workbook, so try it on a copy only.
A tool for it (in preparation)
If walking this table by hand for many files is the problem, I am building Workbook Link Finder, a Windows app that looks without starting Excel. Drop .xlsx or .xlsm files or a whole folder and it checks cell formulas, defined names (including hidden ones), conditional formatting, data validation, charts, shapes and form controls, PivotTables, data connections, and links nothing uses. It lists the sheet, position and target workbook for each, and saves a CSV. It is read-only, never changes your files, and makes no network connections.
What it does not do: it only finds and lists, it does not remove or repair links. It does not read old .xls files, .xlsb files or password-protected files, and it does not look inside macros (VBA) or Power Query. Some places may still be missed, so the result is what the app found, not a guarantee that no other links exist.
Preparing for Microsoft Store
FAQ
I clicked Break Link and the warning is still there. Why?
Break Link replaces formulas that use another workbook with their current values. Microsoft says links kept in defined names have to be removed by deleting the name in Formulas > Name Manager, and that parameters of external data queries need checking separately. Charts, shapes, conditional formatting and data validation also have to be checked one place at a time.
Searching for .xl finds nothing, but Excel says there are links.
If you searched Within: Workbook, Look in: Formulas, the cell formulas are clean. Check the other places in the table: names, conditional formatting, data validation, charts, shapes, hidden sheets.
Does the app find every link?
No. It looks in a fixed set of places and some may still be missed. The result is what the app found, not a guarantee that the workbook has no other links. It does not look inside macros (VBA) or Power Query.
Is a link that nothing uses a problem?
It can keep the update prompt coming. Microsoft notes that older versions of Excel hid links in names that are no longer used; breaking that workbook's link in the Workbook Links pane removes it.
Sources
- ＊1 Microsoft Support: Find links (external references) in a workbook: https://support.microsoft.com/en-us/office/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1
- ＊2 Microsoft Support: Break a link to an external reference in Excel: https://support.microsoft.com/en-us/office/break-a-link-to-an-external-reference-in-excel-f1ca8b08-4f24-4af6-92e5-f4fdb1442748
- ＊3 Microsoft Support: Manage workbook links: https://support.microsoft.com/en-us/excel/manage-workbook-links
- ＊4 Microsoft Q&A: Excel cannot find External Link: https://learn.microsoft.com/en-us/answers/questions/5262137/excel-cannot-find-external-link
- ＊5 Microsoft Tech Community: Searching for external links in Excel workbook: https://techcommunity.microsoft.com/t5/excel/searching-for-external-links-in-excel-workbook/td-p/3818296
Checked 2026-10-22. Menu names follow Microsoft's support articles for Microsoft 365 and were not checked on every version. Microsoft and Excel are trademarks of Microsoft Corporation. This page and the app are not affiliated with, made by or endorsed by Microsoft.
Questions: Support or support@hullspark.com. Privacy policy