How to Stop Excel from Updating External Links Automatically

Excel workbooks often contain links to data in other files. When you open a workbook, Excel tries to update these links automatically. This can cause long delays, security warnings, or errors if the source file is missing. This article explains how to control or disable the automatic update of external links in Excel.

Understanding Excel’s External Link Behavior

External links, also called connections, can point to other Excel files, databases, or web pages. By default, Excel attempts to refresh this data when you open a workbook. This ensures you see the latest information. However, this feature requires access to the source file or location. If the source is on a network drive you are not connected to, or if the file has been moved, Excel will display an error prompt. The automatic update process can also slow down workbook opening significantly. You can change this behavior to manual control or disable it entirely for security and performance reasons.

Methods to Control External Link Updates

You can stop automatic updates through workbook settings, global Excel options, or security settings. The best method depends on whether you want to manage links for one file or change the default for all files.

Disable Automatic Updates for a Single Workbook

Use this method when you only want to change the behavior for the specific file you are working on.

1. Open the workbook with links
   Launch Excel and open the file that contains the external links you want to manage.
2. Go to the Edit Links dialog
   Click the Data tab on the ribbon. In the Queries & Connections group, click the Edit Links button. If this button is grayed out, your workbook has no editable external links.
3. Change the startup prompt
   In the Edit Links dialog, click the Startup Prompt button in the lower-left corner.
4. Select your preferred option
   A new dialog will appear with three choices. Select “Don’t display the alert and don’t update automatic links.” Click OK to confirm.
5. Save the workbook
   Save your file to preserve this setting. The next time you open it, Excel will not try to update the links automatically.

Change the Default Setting for All New Workbooks

This method changes Excel’s global setting, affecting how it handles web queries and certain data connections in new files.

1. Open Excel Options
   Click File > Options to open the Excel Options dialog box.
2. Navigate to Advanced settings
   In the left pane, select the Advanced category. Scroll down to the General section.
3. Open Web Options
   Click the Web Options button located in this section.
4. Modify the Files tab settings
   In the Web Options dialog, go to the Files tab. Uncheck the box labeled “Update links on save.” Also, uncheck “Check if Office is the default editor for web pages.” Click OK.
5. Apply the changes
   Click OK again to close the Excel Options dialog. This setting will apply to future workbooks you create.

Use Trust Center Security Settings

The Trust Center provides the strongest block, preventing automatic updates for all types of external content, including links and data connections.

1. Access the Trust Center
   Go to File > Options. Select Trust Center from the left pane, then click the Trust Center Settings button.
2. Go to External Content settings
   In the left pane of the Trust Center window, select External Content.
3. Change the security settings for workbook links
   You will see two sections. In the “Security settings for Workbook Links” section, select the option “Disable automatic update of Workbook Links.”
4. Confirm and close
   Click OK to close the Trust Center window, then click OK again to close Excel Options. This setting takes effect immediately for all workbooks.

Common Mistakes and Limitations

Edit Links Button is Grayed Out

If the Edit Links button on the Data tab is unavailable, your workbook may contain links that Excel cannot manage through that dialog. These are often embedded objects or links created by certain add-ins. To find them, try using the Find command (Ctrl+F) and search for .xl to locate file references in formulas.

Links Still Update from PivotTables or Queries

Data connections for Power Query, Power Pivot, or PivotTables connected to external data are managed separately. To stop their automatic refresh, go to Data > Queries & Connections. Right-click the query in the pane, select Properties, and change the refresh settings to manual.

Security Warning Still Appears

Even with automatic updates disabled, Excel may show a security warning bar stating “This workbook contains links to other data sources.” This is a separate security notification. You can click Enable Content if you trust the links, or leave it disabled. The links themselves will not update unless you manually trigger them.

Manual Update vs. Automatic Update: Key Differences

Item	Manual Update	Automatic Update
Control	User initiates refresh via Data > Edit Links > Update Values	Excel refreshes on file open
Performance	Faster workbook opening, no waiting for external sources	Can cause slow opening if sources are slow or unavailable
Data Freshness	Data may be outdated until manually refreshed	Always shows the latest data from the source
Error Handling	User chooses when to deal with broken link errors	Errors interrupt the file opening process
Best Use Case	Static reports, archived files, or when source access is intermittent	Live dashboards where up-to-the-minute data is critical

You can now prevent Excel from slowing down by stopping automatic link updates. Use the Edit Links dialog for single files or the Trust Center for a global setting. Remember that Power Query connections have separate refresh controls. For advanced control, use the Workbook_Open event in VBA to manage updates with custom logic.