File Format & Compatibility

Remove External Links That Remain in an Excel Workbook

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

Remove external workbook links that still appear after breaking links in Excel.

Remove External Links That Remain in an Excel Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook previously referenced other workbooks, and the user wants to remove the remaining external references.
Observed behavior
Excel continues to show some external links after others have been broken.
Before you start

Identify which external workbooks are still listed under Data > Edit Links or Workbook Links. Breaking a link replaces linked formulas with their current values and cannot be undone, so confirm that those formulas are no longer needed.

Solution 1Recommended

Break links and inspect defined names and validation rules

Use this approach when Excel still lists external workbooks after links appear to have been broken.

1
Break the listed links

Open the workbook and go to Data > Edit Links, or Data > Workbook Links in newer versions. Select an unwanted source and choose Break Link.

2
Check defined names

Go to Formulas > Name Manager. Inspect the Refers to column for external workbook references, then edit or delete names that are no longer needed.

3
Inspect validation rules

On each relevant worksheet, go to Home > Find & Select > Go To Special > Data Validation. Select a highlighted cell and open Data > Data Validation to inspect its source. Replace or remove rules that use unwanted external references.

4
Save and reopen

Choose File > Save, close the workbook, and reopen it. Check Data > Edit Links or Workbook Links again to see whether the external sources remain.

Break links and inspect defined names and validation rules
Check validation rules individually: Removing a validation rule also removes its restrictions or drop-down list. Edit the source instead when the rule is still needed.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and continue editing in WPS Spreadsheets; use Excel's link tools to resolve persistent Excel links.

Open and edit spreadsheets in a familiar worksheet interfaceCompatible with Microsoft Excel formats such as XLSX and XLSReview formulas and workbook content in WPS SpreadsheetsMove existing Office files into a free, lightweight productivity suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel still show a link after I break it?

A reference may remain in a defined name, formula, validation rule, chart, or another workbook object. Check Formulas > Name Manager and search the workbook's formulas for the external filename.

What happens when I select Break Link?

Excel replaces formulas linked to the selected external workbook with their current values. This action cannot be undone, and it may not remove references stored elsewhere.

How can I find cells with data validation?

On a worksheet, go to Home > Find & Select > Go To Special > Data Validation. Select a highlighted cell and open Data > Data Validation to inspect its rule.

Where is Edit Links in newer versions of Excel?

Look on the Data tab for Workbook Links. Depending on your Excel version, the command may instead be called Edit Links.