How to Remove External Links in Excel

When you send a model to a client or archive a finished file, external links are a liability. The recipient sees a security prompt about updating links to files they do not have, and the numbers can silently go stale. Here is how to remove them cleanly.

Break links from the Edit Links dialog

The built-in way to remove a link is to break it, which replaces every linked formula with its last calculated value.

1. Save a backup copy first, because breaking links cannot be undone.
2. Open the Data tab and click Edit Links in the Queries & Connections group.
3. Select the source file you want to remove.
4. Click Break Link, then confirm. The linked formulas become static values.

Clean up hidden references

Breaking links from the dialog handles formula links, but references can also live in defined names, chart data ranges, conditional formatting, and data validation. If Edit Links still lists a source after you break the obvious links, open the Name Manager (Ctrl+F3) and delete any names pointing at external files, then re-check the dialog.

Verify the file is clean

After removing links, reopen the file. If Excel no longer shows the update-links security prompt and the Edit Links button is greyed out, the workbook is self-contained. It is worth searching formulas for the [ character one more time to confirm nothing slipped through.

Convert linked formulas in one step with ModelMint

ModelMint Hardcode Links removes external links by converting every formula that points to another workbook into its current value, so the file no longer depends on outside files. Instead of breaking links source by source and chasing leftover references, you resolve them in a single pass. It targets external workbook links specifically, leaving your other formulas untouched.