Find broken external links when Break Links fails
Break Links fails when Excel’s link dialog cannot see the reference that is still in the package. The reference may sit in a defined name, a formula the dialog skips, or an externalLink part whose path no longer exists. List the stored targets first. Update a path you still need, and remove a path you do not, from Excel, on a copy.
What a link looks like in the file
A modern workbook records an external workbook in xl/externalLinks. A relationship points at a path or a URL. The link XML can name the sheets in the other file. Formulas then refer to that file in brackets, as in [Budget.xlsx]Sheet1!A1. Defined names can hold the same kind of formula and never appear as a normal cell. This is why a workbook can ask to update links on open while Edit Links looks empty or while Break Links reports that it has nothing to do. The pointer is still in the package.
Find the target before you break it
Run the external-link finder. Read the path exactly. A drive letter, a server share, and a URL are three different problems. The formula-hit count tells you whether scanned cells still mention the file name. A zero does not mean the link is unused. Check the named-range auditor for an external name. Check charts if a series was built from the other workbook. The finder does not open the other file and does not test whether the path exists. Existence is something you can check on your own computer after you know the path. Sending the path to a website to “validate” it would be the opposite of a private check.
Update, break, or rewrite
If the other file should remain the source, use Data, Edit Links, Change Source, and point at the location your recipients can actually reach. Prefer a path that makes sense for them, not only for the machine that built the file. If the other file was a one-time import, Break Links will replace formula references with values when Excel sees the link. Where it does not, edit the name in Name Manager or rewrite the formula. Save and run the finder again. The target should be gone. If it remains, you edited a different copy than the one you measured, or another name still holds it.
Links that are not workbook links
A hyperlink on a cell to a web page is not this problem. An image pasted into the file is not a link. It is a media part and a size question. An OLE object that still points outside the package is in scope, and the finder includes that relationship type. A query that refreshes from a database may not appear as an externalLink part. Power Query connections live in their own parts. If the workbook pauses on open and this page is empty, look at queries and at pivot refresh, not only at Edit Links.
When you want the numbers from your own workbook, read the link parts locally.
After the links are gone
Calculate. Cells that depended on the other file should now be values, or they should show #REF! if a break failed halfway. #REF! after a break means you removed the source and did not replace the reference with a value. Undo from the copy you kept, and break again, or paste values first and then remove the name. A workbook with no external targets should open without the update-links prompt. If the prompt remains, a startup macro or a query is asking for something else. The macro inventory and the query editor are the next places, not another pass through Break Links.
Sending the file to someone else
A link that works on your PC and fails on theirs is still a broken link for the recipient. Before you send a workbook, the target list should contain only paths you intend them to reach. Everything else should be a value. That is the whole practice. The finder is how you see the list without trusting the dialog that has already failed you once.
Decide link by link
Make a two-column note from the finder: target, and keep or drop. A target you keep needs a path the recipient can open, changed in Excel with Change Source, then checked by opening the file on a machine that is not the author’s. A target you drop needs a value left behind, not a #REF!. Paste values on the dependent range first if Break Links has already failed you, then remove the name or the formula that still mentions the file, then run the finder again. The list should shrink by the targets you dropped and keep the ones you marked keep. If a target you never heard of appears, do not ignore it because the dialog is empty. That unknown path is the reason the prompt still appears for everyone but you. It may be a prior consultant’s drive letter. Dropping it is a decision. Leaving it is also a decision, and it should be a conscious one.
Queries are a neighboring problem
If the finder is empty and the file still tries to reach a server on open, look at Power Query, pivot refresh, and data connections. Those are not always externalLink parts. The symptom is the same kind of wait. The storage is different. This guide stays on workbook links. A connection string is a separate review, and it can contain a server name you would not want to mail onward either. Treat that string with the same care as a path in the finder: if the recipient does not need the server, the connection should not be in the copy you send. After you remove a link, open the file once with the network disconnected if you can. A prompt that still appears is another target, a query, or a macro. A file that opens quietly offline is the result you wanted from this guide. Keep the two-column note with the copy you send, so the next person can see which targets you kept and which values you froze in their place. If a kept path fails on their machine, Change Source is the fix, not another round of Break Links.
Related reading
The closest repair notes are Clean up defined names and Is the XLSM safe to open? .
Walk the same checks in order with the Workbook audit checklist.
The terms behind this guide are External link and Cached cell error .
The paired check for that note is the Excel named range checker.
Questions people ask before trusting the result
Will changing the source update numbers?
In Excel, yes, if the new source has the same sheets and names. Do that in Excel. This site only reads the current targets.
Can a link point at itself?
A workbook can contain a stale link to its own previous name or path. Treat it like any other target. It still prompts, and it still belongs on the list.
Why do I see a path with file:/// ?
That is a relationship target written as a URL. It is still a local or network file. Read the path after the prefix. Do not try to open it from the browser on this page.
Does this remove links?
No. Removal is an Excel save. The page is safe to use on a sensitive file because it does not rewrite the package and does not transmit it.
What if the path is a customer’s private folder?
You now know the workbook contains that path. Decide whether it should be sent onward. The check did not contact that folder.