Excel "Break Links" Not Working

You run Data → Edit Links → Break Links, click through the confirmation, and the workbook still shows the "this workbook contains links" warning next time you open it — or the button is greyed out entirely. Both are common, and both usually trace back to the same root cause: Break Links only breaks what Excel's Edit Links dialog can see, and it can't always see everything.

Why it fails silently

The reference is in a named range, not a formula

Break Links converts external formula references to their last calculated values. It does not reliably clean up named ranges (Name Manager) whose "refers to" still points at the external file. The workbook keeps re-flagging on open because, technically, it still has a link — just one Break Links didn't fully reach.

The reference is in a chart or data validation rule

Chart series and data validation lists can reference external ranges directly. These live outside the formula/named-range layer Break Links primarily targets, so they can survive the operation untouched.

The workbook is protected

A protected workbook or protected sheet can block the Break Links operation from completing on everything it touches, sometimes without a clear error — it just doesn't remove all of them.

The button is greyed out

If Break Links is disabled entirely, Excel usually can't detect any external references through its normal scan — which happens when the only remaining links are in a place it doesn't check by default (again, often named ranges), even though the workbook still behaves as if a link exists.

What to actually check, in order

1. Open Formulas → Name Manager and look for any "Refers to" value containing a file path or square brackets.
2. Click through each chart on every sheet and check its data source for an external file reference.
3. Confirm the workbook and its sheets are unprotected before re-running Break Links.
4. If none of the above turns anything up but the warning persists, the reference is somewhere a manual pass is likely to miss — which is the exact problem a full structural scan solves.

Finding what Break Links couldn't

Sheetopsy doesn't modify your workbook or attempt to break anything — it reads the file's structure locally in your browser and shows you the exact sheet, cell, or named range every external reference lives in, so you know precisely what to fix by hand (or why Break Links keeps failing on it).