Excel File Opens Slowly Because Links Cannot Update: Fix

An Excel file that opens slowly often leaves you waiting for minutes while the status bar shows “Links cannot update.” This happens when Excel tries to refresh external links or DDE references that point to a source file that is missing, moved, or restricted. The delay occurs because Excel repeatedly attempts to connect to each broken link before it gives up and loads the workbook. This article explains why Excel hangs on link updates and provides clear steps to stop the slow opening by managing or removing those broken links.

Why Excel Slows Down When Opening a File With Broken Links

External links in Excel connect a cell in your workbook to a cell in another workbook. When you open the file, Excel tries to locate and refresh every external link. If the source workbook has been renamed, moved to a different folder, deleted, or is on a network share that is currently offline, Excel cannot resolve the link. Instead of failing instantly, Excel spends a significant amount of time—sometimes 30 seconds to several minutes—retrying the connection. During this period, the application is not frozen but is busy performing network or file-system lookups that block the user interface.

The same delay can occur with DDE (Dynamic Data Exchange) links, which are older-style connections used by some third-party applications or Excel add-ins. Excel treats DDE links similarly to external references and attempts to start the source application or locate the data source. If the source is unavailable, the delay repeats for each link.

The root cause is that Excel is designed to preserve data integrity by updating links before you see the file. It does not have a built-in timeout that skips broken links quickly. The only way to fix the slow opening is to control how Excel handles those links or remove them entirely.

Steps to Fix Slow File Opening Caused by Links That Cannot Update

The following steps give you three methods. Choose the one that matches your situation. Method 1 is the fastest temporary fix. Method 2 is the permanent solution for files you no longer need linked. Method 3 prevents the prompt from appearing in the future.

Method 1: Change the Startup Prompt to Skip Link Updates

1. Open the file and wait for it to load
   If the file opens eventually, go to the Data tab. If it never opens, use Method 2 or 3 instead.
2. Go to Data > Edit Links
   In the Connections group, click Edit Links. This opens the Edit Links dialog showing all external links in the workbook.
3. Click Startup Prompt
   At the bottom of the dialog, click the Startup Prompt button.
4. Select the option to suppress automatic updates
   Choose “Don’t display the alert and don’t update automatic links.” Click OK, then Close.
5. Save and reopen the file
   Press Ctrl+S to save. Close and reopen the workbook. Excel will no longer attempt to update the broken links, and the file should open quickly.

Method 2: Break All External Links Permanently

1. Open the file using the Safe Mode workaround
   If the file is stuck on the loading screen, hold the Ctrl key while double-clicking the file. A prompt asks if you want to open it in Safe Mode. Click Yes. Safe Mode disables add-ins and link updates temporarily.
2. Go to Data > Edit Links
   In the Connections group, click Edit Links.
3. Select all links
   Click the first link, then hold Shift and click the last link to select them all.
4. Click Break Links
   Click the Break Links button. Excel warns that this action cannot be undone. Click Break Links again to confirm.
5. Save the file with a new name
   Press F12 to open Save As. Give the file a new name to keep the original as a backup. The new file contains no external links and will open quickly.

Method 3: Disable the Automatic Link Update Setting in Excel Options

1. Open Excel without any file
   Launch Excel and create a blank workbook. Go to File > Options.
2. Go to the Advanced category
   In the Excel Options dialog, click Advanced.
3. Scroll to the General section
   Scroll down until you see the heading “General.”
4. Uncheck the link update option
   Clear the check box for “Ask to update automatic links.” Click OK.
5. Restart Excel and open the file
   Close Excel completely and reopen the slow file. Excel will not prompt about links, and the file should open much faster.

If the File Still Opens Slowly After the Main Fix

Excel Still Hangs Even After Breaking Links

Some files contain hidden links in defined names, charts, or conditional formatting rules that the Edit Links dialog does not show. To locate these hidden links, go to Formulas > Name Manager. Look for names that reference external workbooks, such as =C:\Other\[file.xlsx]Sheet1!$A$1. Delete or edit each such name. Also check chart series formulas and conditional formatting rules for external references.

The File Opens Slowly on One Computer but Not Another

This usually indicates a network issue. The source workbook might be on a network drive that has high latency or authentication delays on that specific machine. Try mapping the network drive with a persistent connection or copy the source file to a local folder. If the link is to a SharePoint or OneDrive file, make sure the file is synced offline before opening the workbook.

DDE Links Cause the Same Delay

DDE links do not appear in the Edit Links dialog. To disable DDE in Excel, go to File > Options > Advanced. Under the General section, uncheck “Ignore other applications that use Dynamic Data Exchange (DDE).” This tells Excel not to respond to DDE requests from other programs, which stops the startup delay. Note that this also disables legitimate DDE features like real-time data from some trading or manufacturing applications.

Startup Prompt Options: What Each Setting Does

Setting	Behavior on File Open	When to Use
Let users choose to display the alert and update links	Shows a dialog asking if you want to update links; the file waits for your response	When you want to decide each time whether to update links
Don’t display the alert and don’t update automatic links	Opens the file without updating any links; no prompt appears	When the source files are permanently unavailable or you open the file only for reference
Don’t display the alert and update automatic links	Automatically updates all links without asking; may cause delay if links are broken	When you trust all source files to be available and up to date

You can now prevent Excel from hanging on broken links by changing the startup prompt, breaking links permanently, or disabling the automatic update setting. Start by using the startup prompt option if you need to keep the links for future use. For files that no longer need external references, breaking the links is the cleanest solution. As an advanced tip, use the Name Manager to check for hidden external references that the Edit Links dialog misses, especially in files inherited from other users or older versions of Excel.