Data Import & Export

Stop Excel from Updating Broken Links and Server Connections

Bushra ParveenBushra Parveen Nov 18, 2026 868 views

Question details

Remove workbook links and external data connections that Excel no longer needs to update.

Stop Excel from Updating Broken Links and Server Connections
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.
Before you start

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.

Solution 1Recommended

Break unwanted links to other workbooks

Use this method to stop updating linked workbook formulas without copying and pasting values manually.

1
Open workbook links

Open the affected workbook in Excel and select Data > Edit Links. In some versions, select Data > Workbook Links instead.

2
Break the links

Select each source workbook you no longer need, choose Break Link, and confirm the warning.

3
Save the workbook

Select File > Save, then reopen the workbook to check whether the link update prompt has stopped.

Check for other link sources: If a prompt remains, check formulas, defined names, charts, and data validation for external references. Breaking a workbook link replaces affected formulas with their current values.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet data in a familiar interfaceUse a free, lightweight Office alternativeMove existing Office documents into a compatible workspace
microsoft office alternative - wps office

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.