How to Remove Data Connections in Excel

Working with external data in Excel is essential for modern analysis, but there are times when you need to sever those ties to finalize a report or clean up your workbook. Removing data connections is a necessary-but-often-confusing task that can leave you clicking through menus without a clear path. This guide will walk you through exactly how to find, manage, and remove any data connection in your Excel file, step by step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Are Data Connections in Excel?

In simple terms, a data connection is a live link between your Excel workbook and an external source of information. This source could be another Excel file, a database (like SQL or Access), a web page, Microsoft Power Query, or a cloud service like SharePoint. These connections allow you to pull data into your worksheets and refresh it automatically, ensuring your reports are always up to date without manual copy-pasting.

So, if they're so useful, why would you want to remove them?

• Security and Privacy: Before sharing a workbook with someone outside your organization, you should remove connections to sensitive internal databases to prevent unauthorized access or data leaks.
• File Size Reduction: Connections, especially those linked to the Power Pivot Data Model, can increase your file size. Removing them helps make your workbook lighter and faster.
• Finalizing a Report: Sometimes, you need to create a static, "point-in-time" snapshot of your data. Removing the connection freezes the data, preventing it from changing unexpectedly.
• Troubleshooting: Corrupted or broken connections can cause annoying "cannot refresh" errors or slow down your workbook. Removing them is often the quickest fix.
• The Data Source No Longer Exists: If the original source file or database has been moved or deleted, the connection is obsolete and should be removed to prevent errors.

How to Find All Data Connections in a Workbook

Before you can remove a connection, you need to know where it is. Excel provides a central hub to see and manage every connection in your workbook. There are two main ways to access this, depending on your version of Excel and how the connection was created.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using the Queries & Connections Pane

For modern versions of Excel (2016 and newer), most data connections are managed through Power Query. These are all visible in the Queries & Connections pane.

1. Navigate to the Data tab on the ribbon.
2. In the Get & Transform Data group, click the Queries & Connections button.
3. A pane will open on the right side of your screen, listing all queries (connections) in the workbook.

This pane shows the name of each query and whether it has been loaded to a worksheet or just exists as a connection-only query.

Using the Workbook Connections Dialog Box

For older connections or those not managed by Power Query, the classic Workbook Connections dialog box is your go-to.

1. Go to the Data tab.
2. In the Queries & Connections group, find and click the Workbook Connections button.
3. A dialog box will pop up, displaying a complete list of all data connections in the file, including those feeding PivotTables and fetching data from external files.

Method 1: Deleting a Connection with the Queries & Connections Pane

If your connection is a Power Query one, this is the cleanest and most direct way to remove it. Remember, this action cannot be undone, so be certain before proceeding.

1. Open the Queries & Connections pane (Data > Queries & Connections).
2. In the list of queries, find the one you want to get rid of.
3. Right-click on the query name to open the context menu.
4. Select Delete.
5. Excel will ask for confirmation: "Deleting the query will remove it from the workbook and any worksheet where it resulted in a table." Click OK.

Important Note: This action removes the query (the instructions for getting the data) and the connection. However, if the data was loaded into your worksheet as a table, that table of data will remain. It just becomes a simple, static Excel table, completely disconnected from its original source. If you want to delete the data as well, you must delete that table from the worksheet separately.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Using the Workbook Connections Dialog Box

This method works for almost any type of data connection and is particularly useful for those linked directly to PivotTables or sources that aren't Power Query based.

1. Go to the Data tab and click on the Workbook Connections button.
2. Scroll through the list in the dialog box and select the connection you want to remove. The box below will show you exactly where in your workbook that connection is being used (e.g., "PivotTable1 on Sheet1").
3. With the connection highlighted, click the Remove button.
4. Excel will show a warning: "Removing a connection will permanently delete it from the workbook." Click OK to confirm.

Like the previous method, this removes the connection but leaves any resulting data (like a data table) in place as static values.

How to Remove Connections Used by a PivotTable

If you try to remove a connection directly linked to a PivotTable, Excel will stop you with an error message saying, "This connection cannot be removed because it is being used by a PivotTable report."

This is a protective measure. To remove the connection, you must first unlink it from the PivotTable. The easiest way to do this is to convert the PivotTable into static values, essentially "flattening" it.

1. Select your entire PivotTable, including its headers and values. A quick way is to click any cell inside the PivotTable and press Ctrl + A.
2. Copy the selected data (Ctrl + C).
3. Right-click on the top-left cell of your selected area and choose Paste Special. From the options, select Values, then click OK.
4. Your PivotTable will be replaced by a range of normal cells containing its last saved values. It is no longer an interactive PivotTable.
5. Now that the PivotTable is gone, the underlying data connection is no longer in use. You can go back to the Workbook Connections dialog box (Data > Workbook Connections), select the connection, and click Remove without getting an error.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Break Links to Other Excel Files

Sometimes, your workbook is connected not to a database, but to another Excel file. This is common in summary reports that pull data from various department spreadsheets. Removing these external links requires a different tool.

1. Go to the Data tab on the ribbon.
2. In the Queries & Connections group, click on Edit Links. Note: If this button is grayed out, it means your workbook has no active links to other files.
3. The Edit Links dialog box will appear, listing all source files your workbook is connected to.
4. Select the link (or links) you want to remove. You can select multiple by holding down the Ctrl key.
5. Click the Break Link button.
6. Excel will display a warning: "Breaking links is an irreversible action and will convert formulas and external references to their current values." Confirm by clicking Break Links.

This process replaces any formulas that were pointing to the external file with the static values they last calculated. For example, a formula like =[ExternalReport.xlsx]Sheet_A!$A$1 would be replaced with whatever value was in that cell (e.g., 1500).

Final Thoughts

Cleaning up data connections keeps your Excel workbooks organized, secure, and running smoothly. By using the Queries & Connections pane or the Workbook Connections dialog, you can easily identify and remove outdated or unnecessary links, while the Break Links feature provides a fail-safe for finalizing reports tied to other spreadsheets.

Having to constantly manage and remove connections in spreadsheets is often a sign that you're manually stitching together data from too many places. To fix this, we've automated the entire reporting process in Graphed. Instead of pulling CSVs and connecting workbooks, you connect your sources - like Google Analytics, Salesforce, or Shopify - once, and our AI-powered dashboards update in real time. This means you get a complete view of your business performance without the manual reporting headaches in Excel.