How to Break Links in Excel

Breaking a link tells Excel to stop pulling values from another workbook and keep the last result as a fixed number. It is the standard way to finalize a model so it no longer depends on source files. Here is how to do it without losing data.

What breaking a link actually does

When you break a link, Excel replaces every formula that references the chosen workbook with the value it currently shows. The number stays, but it becomes static and will not refresh again. This is exactly what you want for a delivered or archived file, and exactly what you do not want mid-build, so timing matters.

Break a link step by step

The Edit Links dialog is where all link breaking happens.

1. Make a backup copy of the workbook, since breaking links cannot be undone.
2. Go to the Data tab and click Edit Links in the Queries & Connections group.
3. Select one source file, or hold Ctrl to select several.
4. Click Break Link and confirm at the prompt. The dialog removes the source once its formulas are converted to values.

When breaking links does not finish the job

If a source refuses to leave the Edit Links list after you break it, the link survives somewhere other than a cell formula. Defined names are the usual culprit, followed by chart series and conditional formatting. Open the Name Manager (Ctrl+F3), delete any name whose reference includes a file path in brackets, and try again.

Break every workbook link at once with ModelMint

The Edit Links dialog makes you handle sources one at a time and leaves hidden references behind. ModelMint Hardcode Links takes the same idea further by finding every formula that links to another workbook and converting it to its current value in one action, so the file no longer depends on external files. It is the fastest path when your aim is simply to make a model self-contained.