Excel freezes opening workbooks with data connections

Why Excel freezes on workbooks with data connections

When Excel tries to refresh a data connection during file open, it can hang if the source is unreachable, the query times out, or an add-in conflicts with the connection handler. What's actually happening here is Excel's Workbook_Open event (or a refresh-on-open setting) fires before the UI is fully ready, and one bad connection locks the entire app.

I've seen this most often with ODBC connections to SQL Server that timeout after 30 seconds, or with Power Query queries hitting a SharePoint list that's been moved. The workbook loads, Excel tries to reach the source, and there's no graceful fallback—just a frozen window.

Let's walk through the fixes. Each step is a checkpoint—you can stop when Excel stops freezing.

Quick Fix (30 seconds): Disable refresh on open

This is the first thing I'd try because it takes no time and doesn't require admin rights. The workbook probably has its connection set to refresh when you open it. You just need to kill that behavior.

1. Open Excel without the problematic workbook—start with a blank sheet.
2. Go to Data tab > Queries & Connections > Connections.
3. Click Properties for each connection listed.
4. Uncheck Refresh data when opening the file.
5. Click OK.

The reason this works: You're telling Excel to skip the refresh on open. The workbook will load instantly, and you can manually refresh connections later (Data > Refresh All) after you're in the file. If the workbook still freezes after this, the issue isn't the refresh-on-open setting—it's something else.

Moderate Fix (5 minutes): Start in Safe Mode

If the quick fix didn't help, an add-in could be fighting with the connection code. Excel's Safe Mode loads the app without any add-ins. This isolates the problem.

1. Hold the Ctrl key while double-clicking the Excel icon. A dialog asks if you want to start in Safe Mode—click Yes.
2. Alternatively, run this from the Run dialog (Win+R): excel /safe
3. Now open the problematic workbook.

If it opens fine in Safe Mode, you've got a bad add-in. Which one? Start disabling them one at a time:

1. In Safe Mode, go to File > Options > Add-ins.
2. At the bottom, set Manage to COM Add-ins and click Go.
3. Uncheck all add-ins, restart Excel normally, and test.
4. If it works, re-enable add-ins one by one, restarting each time, until the freeze returns. That's your culprit.

I've seen this happen with Power Pivot and Analysis ToolPak add-ins on Excel 2019 and Office 365. They sometimes hijack the connection refresh process. Removing them fixes the freeze without losing any workbook data.

Advanced Fix (15+ minutes): Break the connection chain

If neither of the above worked, the workbook has a corrupted connection object or a query that's stuck in a loop. You need to surgically remove the broken connection while preserving the data that's already in the cells.

Here's the strategy: Force Excel to open the workbook without refreshing anything, then delete the connection from the inside.

1. Open Excel in Safe Mode (as above).
2. Go to File > Options > Trust Center > Trust Center Settings.
3. Under External Content, select Disable all Data Connections.
4. Click OK, close Excel completely, and reopen normally.
5. Now open the problematic workbook. It should load without attempting any data connections.
6. Go to Data > Queries & Connections > Connections.
7. Right-click each connection and choose Remove. Yes, this deletes the connection definition—but the data that was already in the cells stays.
8. After removing all connections, save the workbook as a new file (use Save As with a different name).
9. Go back to Trust Center and re-enable Enable all Data Connections.

What's actually happening here is you're breaking the link between the workbook and the external source. The data that was imported is now static. If you still need live connections, you'll need to create them fresh from scratch—don't copy the old ones, because they might carry the corruption.

When you can't even open in Safe Mode

If the workbook still freezes even with all connections disabled, you're dealing with a different class of problem—possibly a corrupted file. Try File > Open > Open and Repair (click the arrow next to the Open button). This attempts to reconstruct the file's internal structure. I've seen this recover about 60% of truly stuck workbooks.

Another option: Copy the workbook's worksheet data manually. Open a blank workbook in Safe Mode, then drag the problematic workbook's files into the blank one from Windows Explorer. Excel will try to open the file as an OLE object and extract the data. It's hacky but it's saved me twice when nothing else worked.

Preventing this from happening again

Three things I always do now to avoid future freezes:

• Turn off refresh on open for any workbook with more than 2 connections. You can always refresh manually.
• Set connection timeout limits. In the connection properties (Data > Connections > Properties > Definition), click Command Type and set a timeout under Connection timeout. I use 15 seconds.
• Keep add-ins minimal. Every COM add-in you install is a potential point of failure. Uninstall anything you don't use weekly.

Excel freezing on data connections is almost always a conflict between the app's startup sequence and a remote source that's slow or gone. The fixes above cover 95% of cases. If none of them work, your file might be genuinely corrupted, and you'll need to restore from a backup or rebuild the workbook from scratch.