Stop Excel from Updating Broken Links and Server Connections
Question details
Remove workbook links and external data connections that Excel no longer needs to update.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel workbook contains links or server connections that are no longer needed.
- Observed behavior
- Excel continues attempting to update external workbook links or connect to servers.
Identify which linked workbooks, queries, and connections are no longer needed. Breaking a workbook link converts formulas that use it to their current values, so check that those values are acceptable first.
Break unwanted links to other workbooks
Use this method to stop updating linked workbook formulas without copying and pasting values manually.
Open the affected workbook in Excel and select Data > Edit Links. In some versions, select Data > Workbook Links instead.
Select each source workbook you no longer need, choose Break Link, and confirm the warning.
Select File > Save, then reopen the workbook to check whether the link update prompt has stopped.
Delete unused queries and server connections
Remove imported queries or connections when Excel continues trying to reach an external data source.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. Use Excel to remove its unwanted links and connections; installing WPS does not remove them.

Frequently Asked Questions
What happens when I break an Excel workbook link?
Data > Edit Links > Break Link replaces formulas that use the selected external workbook link with their current values. Those formulas will no longer update from the source.
How do I remove a SQL Server query from an Excel workbook?
Select Data > Queries & Connections, open the Queries tab, right-click the unneeded query, and select Delete. Review the confirmation for any effect on dependent data.
Why does Excel still ask to update links after I break them?
Other external references may remain. Check Data > Edit Links or Workbook Links, and inspect formulas, defined names, charts, and data validation for references to other files.
Can I stop a server connection without manually pasting values?
Yes. Select Data > Queries & Connections, open the Connections tab, right-click the unused connection, and choose Delete. Also check the Queries tab for associated queries that are no longer needed.




