Data Import & Export

How to Fix 'External Data Connections Are Disabled' Warning in Excel

Partner Editor Sep 30, 2026 869 views

Question details

The user is trying to resolve a recurring security warning stating that external data connections are disabled, despite not seeing any obvious queries or links in the file.

How to Fix 'External Data Connections Are Disabled' Warning in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening or working in a workbook that previously imported external data (like CSVs) or contains formulas referencing other files.
Observed behavior: Excel displays a yellow security warning bar about disabled external data connections, even when the user believes there are no external references or active connections.

Before you start

Before modifying your workbook connections, ensure you have saved a backup copy of your file. If you intentionally use data from other workbooks or external sources, removing these links will convert the data to static values.

Solution 1Recommended

Remove Leftover Queries and Connections

Identify and delete leftover connections from imported files (such as CSVs) that trigger the disabled external connections warning.

Importing a CSV file can leave an external connection in the workbook even after the data is saved as an Excel file. Deleting these obsolete connections will usually resolve the warning.

Open Queries & Connections

Navigate to the 'Data' tab on the top ribbon and click on 'Queries & Connections' to open the side panel.

Identify Unwanted Connections

Review the list in the side panel for any unexpected or outdated connections, especially those named after previously imported CSV or text files.

Delete the Connection

Right-click the connection you no longer need and select 'Delete' from the context menu. Save your workbook and reopen it to verify the warning is gone.

Tip: If you just want to update the data instead of removing it, you can click 'Enable Content' on the warning bar, provided you trust the source.

Solution 2

Find and Break External Formula Links

Locate formulas that reference other workbooks, which act as external connections but may not appear in the standard Connections dialog.

Manage Data Smoothly with WPS Office

Easily Manage External Links and Data in WPS Spreadsheet

WPS Office offers a clear, intuitive interface for managing external data and cross-workbook formulas. You can quickly track down unwanted links or securely enable data connections while maintaining full compatibility with Microsoft Excel files.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet displaying the external links warning.
2. Navigate to the Data tab: Click on the 'Data' tab located on the top main ribbon to access your data management tools.
3. Access Edit Links: Click 'Edit Links' to view a comprehensive list of all external workbook references currently active in your document.
4. Break unnecessary links: Select any unwanted links and choose 'Break Link' to convert them to values and permanently remove the security warnings.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Intuitive 'Edit Links' and data management tools to easily track external references.Free and lightweight alternative for seamless daily spreadsheet tasks.Built-in security features to safely manage external data prompts.

microsoft office alternative - wps office

Frequently Asked Questions

Why did an imported CSV file create an external connection?

When you use the 'From Text/CSV' import feature in modern versions of Excel, it utilizes Power Query to connect to the original file. This allows for future data refreshing. This connection remains active in the workbook even if you save it as an .xlsx file, triggering the warning upon reopening.

Is it safe to click 'Enable Content' on the external connections warning?

Only click 'Enable Content' if you trust the source of the file and know exactly what external data is being pulled. Malicious files can exploit external connections to pull harmful data or execute unwanted actions.

How can I disable this external connection warning permanently?

You can change your Trust Center settings by navigating to File > Options > Trust Center > Trust Center Settings > External Content. From there, you can choose to enable all data connections, though this is highly discouraged due to significant security risks.

Why is the 'Edit Links' button grayed out?

The 'Edit Links' button is only active if the application detects standard OLE/DDE links or external cell references within formulas. If it is grayed out, the warning is likely caused by a Power Query, a PivotTable connection, or a hidden named range rather than a direct formula link.

Excel & Data Problems