Guide Files and recovery
Excel keeps asking about a file I deleted years ago
Every time the workbook opens: “This workbook contains links to one or more external sources.” You have run Break Links. The prompt comes back anyway, because the link is not in a cell.
Break Links only handles links in cell formulas. When the prompt survives, the link is in one of four other places: a defined name, a data validation rule, a conditional formatting rule, or a chart series. Defined names are the usual culprit — open Name Manager, sort by Refers To, and delete anything pointing at another file.
Four places Break Links cannot see
An external link is any reference to another workbook. Data → Edit Links → Break Links converts those to values — but only where the reference is in a cell formula. Four other places can hold one, and none of them are touched.
- Defined names. The most common by a distance. A name copied in with a sheet from another workbook still points at that workbook, invisibly, forever.
- Data validation. A dropdown whose source list lives in another file.
- Conditional formatting. A rule whose formula references another workbook.
- Charts. A series pointing at a range in another file.
None of these show up in Edit Links's list in a way that lets you clear them, which is why the prompt appears to be unkillable.
| What you see | What actually happened | What fixes it |
|---|---|---|
| Prompt returns after Break Links | The link is not in a cell formula | Check names, validation, formatting, charts |
| Edit Links lists a file you cannot find | A reference survives in a name or a rule | Name Manager first |
A name shows #REF! | It pointed at a deleted file or range | Delete the name |
| Prompt only on one sheet | A chart or a validation rule on that sheet | Check both there |
| Slow to open | Excel is trying to reach the missing file | Remove the link entirely |
How to find and remove a stubborn external link
Try Break Links first
Data → Edit Links → Break Links. It converts formulas referencing other files into their current values. If the prompt is gone next time you open the file, you are finished.
It cannot be undone, so save a copy first.
Check defined names — the usual culprit
Formulas → Name Manager. Widen Refers To and sort by it.
Anything containing [ and a file name, or showing #REF!, is a broken link.
Select and delete them. Names copied in with a sheet from another workbook are the single most common cause of a link that will not die.
Search the sheet for the bracket
External references always contain a square bracket:
- Ctrl+F, search for
[ - Options → Within: Workbook, Look in: Formulas
- Find All
This catches cell formulas anywhere in the file, including sheets you had forgotten about.
Check data validation and conditional formatting
Validation: Home → Find & Select → Go To Special → Data validation → All. Check the Source box of each for another file name.
Formatting: Conditional Formatting → Manage Rules, set the dropdown to This Worksheet, and read each rule's formula. Repeat per sheet — there is no workbook-wide view.
Check every chart's series
Click a chart, click a series, and read the SERIES formula in the
formula bar. An external reference appears there in full. Repoint or delete it.
Charts are last because they are the rarest cause, and the most tedious to check.
Everything on this page, as a workbook you can use on your own data
The Excel Data Cleanup Kit — a seven-tab workbook that finds all nine of these faults in a pasted column and hands back a cleaned version, a five-page PDF guide, and a short read-me. Free, no email required.
- Excel-Data-Cleanup-Workbook-Free.xlsx — paste a column, read the diagnosis, take the cleaned output
- Excel-Data-Survival-Guide.pdf — the eight failures, the import routine that prevents them, every formula explained
Plain .xlsx: no macros, no add-ins. Opens in Excel, Google Sheets,
Apple Numbers and LibreOffice Calc.
If you still cannot find it
An .xlsx is a zip archive. Copy the file, rename it to .zip, extract it,
and search the extracted files for the missing workbook's name. The folder that contains it tells you
where the link lives — xl/charts/, xl/worksheets/,
xl/workbook.xml for names — and you can then go back to Excel and look in the right
place.
It sounds drastic and it is often faster than hunting through twenty sheets.
Suppressing the prompt is not fixing it
Data → Edit Links → Startup Prompt can hide the message. The link is still there, still reaching for a missing file, and still slowing the workbook down on open. Worse, the next person has no idea it exists. Remove the link rather than the message.
Avoiding it
- Copying a sheet from another workbook brings its defined names. Check Name Manager afterwards, every time.
- Prefer Power Query to formula links across files — it is visible, listed, and manageable in one place.
- Where a link is genuinely wanted, keep both files in the same folder and use relative paths, so moving the pair does not break it.
Questions people ask
Why does Break Links not remove my external link?
It only handles links in cell formulas. The link is likely in a defined name, a data validation rule, a conditional formatting rule or a chart series.
Where do external links usually hide?
Defined names, by a wide margin. A name copied in with a sheet from another workbook keeps pointing at that workbook invisibly.
How do I search for external links?
Press Ctrl+F and search for a square bracket, with Within set to Workbook and Look in set to Formulas. External references always contain one.
Can I just turn off the prompt?
You can, under Edit Links > Startup Prompt, but the link remains — still reaching for a missing file, still slowing the open, and now invisible to the next person.
What if I cannot find it anywhere?
Rename a copy of the file to .zip, extract it, and search the extracted files for the missing workbook's name. The folder it appears in tells you where the link lives.
How do I stop this happening?
Check Name Manager after copying any sheet in from another workbook, and prefer Power Query over cross-file formula links, since it is visible and managed in one place.
Related guides
Take the workbook with you
The Excel Data Cleanup Kit — a seven-tab workbook that finds all nine of these faults in a pasted column and hands back a cleaned version, a five-page PDF guide, and a short read-me. Free, no email required.
- Excel-Data-Cleanup-Workbook-Free.xlsx — paste a column, read the diagnosis, take the cleaned output
- Excel-Data-Survival-Guide.pdf — the eight failures, the import routine that prevents them, every formula explained
Plain .xlsx: no macros, no add-ins. Opens in Excel, Google Sheets,
Apple Numbers and LibreOffice Calc.