Excel Break Links not working

Stop breaking links and find out what is left

Repeating the command does not help if what remains is not the kind of reference it acts on. Each pass is another irreversible edit to a workbook you have already changed, so the first thing to establish is what Excel is actually still seeing.

Break Link works on the workbook links Excel lists in the links pane. A reference that is not in that list is not something the command will clear.

Where a reference usually survives

These are the places worth checking first, in roughly the order they cause the problem.

• Defined names. A name whose Refers to points at another workbook. Hidden names are the common case, because the Name Manager does not show them.
• Chart series. A chart can take its values or its category labels from another workbook. Selecting the series shows the reference in the formula bar.
• Data validation and conditional formatting. Rules built from a range in another file.
• The workbook's own link entries. Excel keeps an entry for each linked workbook, and one can remain after the formulas that used it are gone.

Things that are not workbook links at all

Some of what looks like a leftover link is a different kind of thing, which is why breaking links never removes it.

• Hyperlinks are something you click to open a file or a page. They are managed separately and the workbook links pane does not list them.
• Data connections, Power Query queries and PivotTable sources pull data from outside the workbook, but they are not workbook links and are handled in their own places in Excel.

If one of those is what remains, the links pane is the wrong place to be looking, and no amount of breaking links will change it.

Check it in Excel first

Two searches cover most of it without any extra tooling.

1. Press Ctrl+F, choose Options, set Within to Workbook and Look in to Formulas, then search for [. An external reference in a formula carries the source workbook name in square brackets.
2. Open the Name Manager on the Formulas tab and read the Refers to column for names pointing at another file.

That finds worksheet formulas and visible names. It does not reach hidden names, chart series or rules, which is exactly why a workbook can keep reporting a link after you have searched every sheet. The longer version of this is in finding external links in Excel.

See what is actually in the file

Excel Link Rescue reads a closed .xlsx or .xlsm file and lists the external workbook references it detects, grouped by the workbook they point at. Each source shows how many references reach it and where they are, with the sheet and cell for formulas and the name for a defined name, including hidden ones.

It reports what it finds rather than changing it. Some things it lists are shown so that you know they exist, and are not modified: DDE links, linked OLE objects, Power Query sources, PivotTable sources and data connections. Paths written inside VBA code belong to the macro, not to the workbook's links.

If what remains turns out to be a workbook reference of a supported kind, you can see exactly where it is used and, if the source should still be working, repoint it at the right file. Excel Link Rescue does not break links and does not convert formulas to values, so if removing the dependency is what you want, that stays Excel's own Break Link command, covered in breaking links in Excel.