How to Remove the External Links Warning in Microsoft Excel

Quick Answer

The external links warning in Microsoft Excel appears when a workbook contains links to other workbooks. Excel displays this warning so that you can decide whether to update data from those sources.

To open the workbook without updating external data, click Don't Update. To remove unwanted links permanently, go to Data > Queries & Connections > Workbook Links, select the relevant link and choose Break Links.

If you want to retain the links but stop the warning from appearing every time you open the workbook, change the workbook's refresh settings. Before breaking any links, save a backup because the operation cannot easily be undone.

What Causes the External Links Warning in Excel?

An external workbook link is a reference to data stored in another Excel workbook. For example, a formula in one workbook may retrieve values from another file named Budget.xlsx.

When Excel opens a workbook containing these links, it may display the following warning:

This workbook contains links to one or more external sources that could be unsafe.

The warning allows you to decide whether to retrieve updated information from external sources or continue working with the existing data.

Common reasons for this warning include:

• Formulas referencing another Excel workbook.
• Links to files that have been moved, renamed or deleted.
• Workbooks copied from another computer or shared by someone else.
• External references in defined names, charts or objects.
• Workbooks that depend on external data sources.

The warning does not necessarily mean that the workbook is infected or damaged. It is a security precaution.

Method 1: Remove External Links Permanently

Recommended when the external links are no longer required.

If you no longer need information from other workbooks, you can break the unwanted links. This removes the connection while generally preserving the current calculated results.

Steps to break external workbook links

1. Open the Excel workbook containing the warning.
2. Go to the Data tab.
3. Select Queries & Connections > Workbook Links. In older Excel versions, the command may be called Edit Links.
4. Locate the external workbook link you want to remove.
5. Click the three-dot menu (More Commands) beside the relevant workbook.
6. Select Break Links and confirm the action if prompted.
7. Save the workbook and reopen it to check whether the warning has disappeared.

What happens when you break a link?

Breaking a workbook link generally replaces formulas that depend on the external workbook with their current calculated values.

For example, a formula such as:

=SUM('[Budget.xlsx]Annual'!C10:C25)

may be replaced by its current numerical result. The resulting value will no longer change when the original source workbook is updated.

Warning: Breaking links cannot easily be undone. Save a separate backup copy before proceeding. If the original formulas are needed later, restore them from the backup.

Method 2: Stop the Warning Without Removing Links

Recommended when you still need the external links.

If you want to retain external links but do not want Excel to ask about updating them every time the workbook opens, change the workbook's refresh settings.

Steps to disable the update prompt for a workbook

1. Open the workbook in Microsoft Excel.
2. Go to Data > Queries & Connections > Workbook Links.
3. Open Refresh settings in the Workbook Links pane.
4. Select Don't refresh.
5. Save the workbook.

The available refresh settings generally include:

Setting	Function
Ask to refresh	Asks whether to update the workbook links when the workbook opens.
Always refresh	Automatically updates the workbook links when the workbook opens.
Don't refresh	Does not automatically update links or ask for permission when the workbook opens. You can refresh them manually when needed.

This setting controls the normal refresh prompt for the workbook. Other security warnings or broken-link notifications may still appear.

Method 3: Disable the Update Prompt for All Workbooks

If the same update prompt appears in several workbooks, you can change Excel's general settings. This is a user-level setting and affects other workbooks opened by the same user.

Steps

1. Open Microsoft Excel.
2. Go to File > Options.
3. Select Advanced.
4. Scroll down to the General section.
5. Clear the checkbox labelled Ask to update automatic links.
6. Click OK.

When this option is cleared, Excel updates eligible automatic links without displaying the usual update prompt.

Important: This setting affects all workbooks opened by the current user. Automatic updates can retrieve data from external sources without asking each time. Use this option only when you trust the linked sources.

Method 4: Find Hidden External Links

Sometimes, the Workbook Links pane does not reveal every external reference that may be responsible for a warning. Links can also exist in formulas, defined names, charts and objects.

1. Search formulas for external links

1. Open the workbook.
2. Press Ctrl + F to open Find and Replace.
3. Click Options.
4. Enter .xl in the Find what field.
5. Set Within to Workbook.
6. Set Look in to Formulas.
7. Click Find All.
8. Review the results for formulas containing external workbook references.

This search can help locate references to Excel files, but it does not identify every type of external link.

2. Check Name Manager

External links may also be stored in defined names, including names that are not immediately visible on worksheets.

1. Go to the Formulas tab.
2. Select Name Manager.
3. Review the Refers To column for external workbook references, such as [Budget.xlsx].
4. Edit or delete only those names that you have confirmed are unnecessary.

Be careful when deleting defined names because other formulas, charts or workbook features may depend on them.

3. Check charts and objects

External references may also be embedded in chart titles, chart data series, shapes and text boxes.

Inspect relevant charts and objects, particularly if the Workbook Links pane shows no remaining links but the warning continues to appear. Excel does not provide one automatic method that finds every possible external reference.

Method 5: Review External Content Security Settings

Excel provides additional security settings for managing external workbook links. These settings are useful when you need to control how Excel handles external data across workbooks.

Steps to review the settings

1. Open Excel and select File > Options.
2. Go to Trust Center.
3. Click Trust Center Settings.
4. Select External Content.
5. Review the options under Security settings for Workbook Links.

Security setting	Behaviour
Prompt user on automatic update for Workbook Links	Displays a security warning before automatic updates. This is the default option.
Enable automatic update for all Workbook Links	Allows automatic updates without the usual security warning.
Disable automatic update of Workbook Links	Prevents automatic updates of external workbook links.

Enabling automatic updates for all workbooks is not recommended unless you trust their sources. These settings affect security behaviour more broadly than the refresh settings for an individual workbook.

How to Verify That the Warning Has Been Removed

After changing the settings or removing unwanted links, verify that the warning no longer appears.

1. Save the workbook.
2. Close the workbook completely.
3. Reopen the saved file in Excel.
4. Check whether the external links warning appears again.
5. If the warning persists, inspect the Workbook Links pane and check for other external references.

If all relevant workbook links have been removed, the usual external workbook update warning should no longer appear. However, unrelated security warnings or external data connection prompts may still be displayed.

Common Problems and Troubleshooting

Problem	Possible cause	Recommended solution
Warning appears even after breaking links.	Other external references may remain.	Check formulas, defined names, charts and objects.
Workbook Links is unavailable.	The workbook may not contain supported workbook links, or the command may differ by Excel version.	Check for external references and other data connections.
Warning appears only on one computer.	Excel's user-level update settings may differ.	Review the Ask to update automatic links option.
Workbook displays old values.	Automatic updates may be disabled.	Refresh the links manually if the sources are trusted.
Links become broken after moving files.	The source workbook may have been moved or renamed.	Use Change Source to select the correct workbook.
Warning returns after saving.	Some external references or connections may remain.	Inspect the workbook again and check its remaining links.

Frequently Asked Questions

1. Is it safe to click Don't Update in Excel?

Generally, yes, if you want to retain the existing data and do not need the latest values from external workbooks. However, the stored values may be outdated. You can update the links manually later if required.

2. Does breaking external links delete data?

Breaking workbook links generally preserves their current calculated results by replacing linked formulas with values. However, it removes the formulas' connection to the original sources. Always keep a backup before proceeding.

3. Can I remove external links without changing existing values?

Yes. Breaking links normally replaces linked formulas with their current calculated values. The values remain, but they will no longer update when the source workbook changes.

4. Why does Excel show the warning even when I cannot find any links?

External links can exist in defined names, chart data series, shapes, text boxes and other objects. Inspect these areas in addition to the Workbook Links pane.

5. Can I disable the warning for only one workbook?

Yes. Open the Workbook Links pane, expand Refresh settings and select Don't refresh. This retains the links but suppresses the normal update prompt for that workbook.

6. Will disabling the warning remove external links?

No. Disabling the update prompt changes how Excel handles updates; it does not remove the links. To remove them, use Break Links or remove the relevant external references.

7. Why does the warning appear in an Excel file received from someone else?

The workbook may contain formulas linked to other workbooks or external data sources. These links may have been created by the original author and retained when the file was shared.

8. Does this warning mean my Excel file contains a virus?

No. The warning indicates that the workbook contains external links that may require attention. It does not, by itself, mean that the workbook contains malware. Only update links from sources you trust.

Conclusion

The external links warning in Microsoft Excel is a security prompt, not necessarily a workbook error. The appropriate solution depends on whether the external data is still required.

• Don't Update: Open the workbook using its existing data without refreshing external links.
• Break Links: Remove unwanted external workbook references while retaining their current calculated values.
• Don't refresh: Retain links while suppressing the normal update prompt for the workbook.
• Inspect hidden links: Investigate persistent warnings that remain after removing visible links.

If a workbook no longer depends on external sources, removing unnecessary links can simplify its maintenance. If the links are still required, retain them and control their refresh behaviour according to your needs.

Sources

• Microsoft Support: Manage workbook links – Instructions for refreshing, changing, breaking and locating workbook links.
• Microsoft Support: External links found – Explains how Document Inspector identifies external links and what to do about them.
• Microsoft Support: Description of workbook link management and storage in Excel – Explains how workbook link paths are stored and managed.
• Microsoft Support: Block or unblock external content in Office documents – Describes external content security settings.
• Microsoft Support: How to avoid broken formulas in Excel – Explains external references and update prompts.