How to break links in Excel when Break Link doesn’t work
- Open the workbook here. It is read in your browser; nothing is uploaded.
- See every link and where it hides. For each source workbook you get the full path and every place that uses it: formulas, defined names, data validation lists, conditional formatting and charts.
- Untick the links you want to keep. The remaining links are renumbered so they keep working.
- Download the copy. Formulas become their last saved values and the link parts are removed from the file, so Excel stops asking you to update links.
Why Excel’s Break Link fails
Data › Edit Links › Break Link only converts formulas in cells. A link that lives somewhere else survives, and Excel keeps showing the security warning or the update prompt. The usual hiding places are:
- Defined names that refer to another workbook (Formulas › Name Manager), often hidden or left over from copied sheets.
- Data validation lists and conditional formatting rules whose source is in another file.
- Charts whose series point to another workbook.
- Protected sheets: Break Link can’t change formulas on them.
- Orphan links that no formula uses any more but are still stored in the file.
This tool works on the file itself, so it finds all of them, including on protected or hidden sheets.
When the source workbook has been moved, renamed or deleted, Excel shows a message saying it can’t update some links, and Edit Links reports the status “Error: Source not found”. You don’t need the source file to break the link: the last values Excel read from it are saved inside your workbook, and those are the values this tool keeps. If a formula never got a saved value, the tool tells you which cells will be left empty before you download.