Excel External Links Error: Causes and Fixes

Errors & fixes · Updated November 19, 2026

An Excel external links error usually means a workbook cannot find, access, or safely update another workbook referenced by a formula. In Microsoft 365 for Windows, open Data > Workbook Links, check the source path and update permissions, then change the source or break the link only if you no longer need live values.

What an Excel external links error means

An external link connects a cell, name, chart, or other workbook content to information stored in a different file. Excel may show a warning when a workbook opens because it contains links, or it may report that it cannot update a source. These messages are not all the same: a prompt to update links is a request to refresh data, while a missing-source message means Excel could not retrieve it. A workbook can also open without an obvious error and still display old linked values.

Whether a link is a problem depends on what the workbook is meant to do. A monthly report that should reflect a separate sales workbook needs a working link. An archived report whose numbers should remain fixed may not. Before changing anything, identify whether the displayed values are expected to update and whether the source file is trusted and available.

How workbook links work

A formula can point to a cell in another workbook. For example, with a source file named Budget.xlsx, a worksheet named Summary, and the value to retrieve in B4, a destination workbook might contain this formula:

='C:\Reports\[Budget.xlsx]Summary'!$B$4

This example assumes the source workbook is at C:\Reports\Budget.xlsx and B4 contains 12500; if Excel can read that cell, the linked result is 12500. The actual path and sheet name in your formula will depend on where the file is stored. Excel may use a shorter reference when both workbooks are open, or a relative path when files are moved together.

Workbook links are different from hyperlinks. A hyperlink opens a destination when clicked; it does not normally import a cell’s current value. They are also different from Power Query connections and other data connections, which retrieve or transform data through their own settings. A workbook can contain one kind of connection, several kinds, or none at all, so the right repair depends on what Excel identifies.

Find the link and identify the source

In current Microsoft 365 Excel for Windows, select Data > Workbook Links to open the links pane, then inspect the listed source workbooks and their status. Available commands and labels can vary with the Excel build and workbook. In older Windows versions, the command may appear as Data > Edit Links. If neither command is visible, confirm that you are using the desktop app and check for updates; Excel for the web and Mac do not always offer identical link-management controls.

When the pane does not reveal the link you need, search the workbook. Press Ctrl+F on Windows (Command+F on Mac), search for an opening square bracket such as [, and set the search to look in formulas and within the workbook. External workbook formulas commonly include a bracketed file name. A search is a useful clue, not a complete audit: references can also be stored in defined names or chart series, and different link types may not appear as ordinary cell formulas.

  • Review Formulas > Name Manager for names whose Refers to field points to another file.
  • Inspect chart series if a chart is showing unexpected values; select the chart and review its data references.
  • Check Data > Queries & Connections for a query or connection rather than a formula link.
  • Note the exact source file name and path, and ask whether it was renamed, moved, stored on a disconnected network drive, or made unavailable by permissions.

Repair a broken or outdated link

Start with the least destructive fix. If the source workbook still exists, make sure you can open it from the same computer and account. A file in a cloud or network location may be temporarily unavailable, not permanently missing. Check that you have permission to read it, that the folder is synchronized if applicable, and that the source workbook has not been renamed. Reopen the destination workbook after restoring access, then use its links pane to update values.

If the source has moved or been renamed, use Workbook Links and choose the command to change the source, then select the correct workbook. In older versions, use the corresponding option in Edit Links. Verify the result in several cells that should have changed; a successful update does not guarantee that every reference points to the intended sheet or range. If the correct file is uncertain, compare its contents before redirecting the link.

If Excel asks whether to update links when opening the workbook, choose to update only when you trust the source and want current values. Choosing not to update can leave the workbook showing the last saved linked values. That may be acceptable for an offline snapshot, but it is not proof that the numbers are current. Avoid repeatedly clicking update without checking the source: a different file with the same name could contain different data.

When breaking a link is appropriate

Breaking a link removes the live connection. For a formula link, Excel typically replaces the formula with its current value, so future edits to the source will no longer flow into the destination. The displayed number may look unchanged immediately after breaking the link, which can make the operation seem harmless; the important change is that the formula is gone. If you later need live updates, you will have to recreate the reference or restore a backup.

Use the break-link command only after deciding that fixed values are acceptable. Save a separate copy first, especially if the workbook supports a recurring report or contains many formulas. Then use the links pane or Edit Links to select the source and break its link, if that command is available. Review key sheets and formulas afterward. Breaking a workbook link is not the same as deleting a hyperlink or removing a Power Query connection, and some connection types require separate management.

Security and update prompts

External links can bring in information from files outside the workbook, so Excel may ask whether to update them or may restrict updates according to security settings. A warning does not automatically mean the file is malicious, but it is a reason to verify who supplied the workbook and where its sources point. A link to a known company report is different from an unexpected source path in a file received by email.

On Windows, external-content controls are available through File > Options > Trust Center > Trust Center Settings > External Content. The precise controls shown can depend on the Excel version and organizational policy. Do not globally enable external content just to silence a prompt. If a work device is managed, an administrator may control these settings; ask for help rather than trying to bypass the policy. On Mac, settings and menus differ, so use Excel’s preferences and current Microsoft support guidance for that version.

Common causes and misconceptions

  • The source was moved or renamed: Excel still refers to the old location or file name. Restore the expected path or redirect the link to the verified replacement.
  • The source is unavailable: A network drive, cloud folder, or shared location may be offline, unsynchronized, or inaccessible to your account.
  • The workbook has stale cached values: The visible result can be the last saved value, not a fresh result from the source. Check link status and update deliberately.
  • A prompt is mistaken for a broken link: Excel can ask about updates even when the source exists. The prompt alone does not tell you that the reference is invalid.
  • A hyperlink is mistaken for a workbook link: A clickable address does not generally supply cell values to formulas.
  • A query is mistaken for a formula link: Queries and connections have separate refresh settings and may need to be repaired through Queries & Connections.

Another common misconception is that closing the source workbook breaks every link. Excel can often update external references from a saved source file without that source being open, provided the file is reachable and accessible. Conversely, having the source open does not fix a wrong path or a reference to a deleted sheet.

Prevent link errors in shared workbooks

Make the workbook’s dependencies clear to the people who maintain it. Keep linked source files in a stable, shared location, avoid changing names casually, and document which reports depend on which source files. When distributing a snapshot, decide whether recipients need live updates or fixed values, and tell them what the workbook expects. Before moving a group of files, test the destination copy rather than assuming every reference will follow automatically.

For a workbook that should not rely on external files, check links before sending it. Review the links pane, defined names, charts, and any queries or connections, then remove only dependencies that are genuinely unnecessary. Keep an untouched copy while auditing. If links are part of the reporting process, maintain the source files and access permissions instead of breaking links simply to suppress an opening message.

Frequently Asked Questions

Why does Excel say it cannot update links?
Excel could not retrieve data from at least one referenced source. The file may have moved, the location may be offline, access may be denied, or the reference may point to a renamed workbook. Check the source path and availability in Workbook Links before changing or removing it.

How do I find external links that are not obvious?
Search formulas for a bracketed workbook name, then inspect Formulas > Name Manager and chart data references. Also check Data > Queries & Connections, because a query or connection is not necessarily listed as a cell-formula link.

Will breaking an Excel link delete the displayed number?
For formula links, Excel generally replaces the formula with its current value, so the number remains but no longer updates from the source. Make a backup first and confirm that a fixed value is what you want.

Can I update links without opening the source workbook?
Often, yes. Excel can read a saved source file if its location is reachable and you have permission. If the source is unavailable or the reference is wrong, opening the destination alone will not repair it.

Is it safe to click Update in the links warning?
It is reasonable when you trust the workbook and recognize its source files. If the workbook came from an unexpected sender or points to an unfamiliar location, do not enable updates until you verify the source; you can choose not to update and investigate first.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.