Remove External Links That Remain in an Excel Workbook
Question details
Remove external workbook links that still appear after breaking links in Excel.

- 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.
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.
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.
Open the workbook and go to Data > Edit Links, or Data > Workbook Links in newer versions. Select an unwanted source and choose Break Link.
Go to Formulas > Name Manager. Inspect the Refers to column for external workbook references, then edit or delete names that are no longer needed.
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.
Choose File > Save, close the workbook, and reopen it. Check Data > Edit Links or Workbook Links again to see whether the external sources remain.

Search formulas and workbook objects for remaining references
Use this when links remain after checking defined names and data validation.
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.

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.




