Excel Not Updating Links From Other Workbooks? Fixes

How-to basics · Updated November 18, 2026

If Excel is not updating links from other workbooks, first open the source workbook and use Data > Workbook Links to refresh the link; then check that the source file has not moved and that calculation is set to Automatic. If Excel still shows an old value, the issue may be a broken file path, a security prompt, or a data connection rather than a formula link.

What an external workbook link is

An external workbook link is a reference in one Excel file to a cell or range in another file. It can display a value from the source workbook, such as a monthly sales total, without copying that value manually. The destination workbook stores a reference to the source file and may also retain the last value it received. If Excel cannot reach the source, that saved value can remain visible even though the source has changed.

For example, if the source workbook is Sales.xlsx, its January sheet has the relevant value in B2, and the destination workbook places the reference in C2, the link can look like ='[Sales.xlsx]January'!B2. This assumes both workbooks are available in a location Excel can resolve. Excel may add a folder path to the reference when it saves the link.

Not every connection between files is this kind of link. A workbook can also import data with Power Query, connect to a database, or use a PivotTable connected to an external source. Those sources have their own refresh controls and may need credentials. Identifying which type you have prevents you from repeatedly refreshing the wrong feature.

How Excel updates workbook links

When a linked workbook opens, Excel may ask whether to update links. Choosing to update tells Excel to try to retrieve current values from the source. Choosing not to update leaves the destination workbook displaying the values it previously saved. That choice does not necessarily remove the link; it simply means Excel did not fetch new source values at that opening.

In Microsoft 365 for Windows, go to Data > Workbook Links to inspect and refresh workbook links. Depending on the Excel build, or in older versions, the command may appear as Data > Edit Links. The pane or dialog can show the source workbook and help you refresh values, change a source, or review links that need attention. If the command is unavailable in Excel for the web, open the file in the desktop app for link-management tasks.

Refresh is distinct from recalculation. Refresh retrieves values from the linked file; recalculation updates formulas based on the values already available to the workbook. If you refresh successfully but formulas elsewhere still look stale, check calculation settings. If formulas recalculate but the linked cell itself remains old, focus on the source path, link status, or update permission.

Check the source file and its path

A link can stop updating after someone renames, moves, replaces, or deletes the source workbook. Moving a folder can be enough to break a reference if Excel can no longer locate the saved path. The source might also be on a network drive, removable disk, or cloud location that is disconnected or not yet synchronized.

Open Data > Workbook Links and inspect the listed source. If Excel identifies a broken link, use its change-source option to point the destination workbook to the correct file. Select the intended source workbook carefully: a different file with the same name can contain different data, and changing the source can affect many formulas at once. After correcting the source, refresh and check a few known values against the source workbook.

  • Confirm that the source workbook exists and opens normally.
  • Check that you have permission to read it, especially on a shared drive or SharePoint location.
  • If the file was moved, use the current location rather than creating a second copy just to match the old path.
  • If the source is stored in OneDrive or SharePoint, allow synchronization to finish and confirm that you are signed in to the account with access.

For a reliable test, open both workbooks from their normal locations, change a harmless test value in the source if appropriate, save it, and then refresh the destination. Avoid changing business data simply to test a link; compare a known value instead. If the refresh works only while both files are open, that is useful evidence that Excel can resolve the source in the open session but has trouble reaching it in its saved location or through its current permissions.

Check update prompts and security settings

Excel treats links to other files as external content, so a prompt or security control may prevent an automatic update. If you see a message asking whether to update links, read it and confirm that you recognize the source before allowing access. For a workbook from an unknown sender, do not enable external content just to make the warning disappear. A linked file can expose information or pull in data you did not intend to trust.

If Excel opens the workbook without asking, it may be following a saved choice or an organization-managed security policy. Check the message bar, File > Info, and Data > Workbook Links for notices or link status. In managed workplaces, an administrator may restrict external content; ask them about the policy rather than trying to bypass it. Trust Center settings and available controls can vary by Microsoft 365 build and organizational configuration, so avoid changing broad security settings unless you understand their effect.

A prompt is not proof that the link is broken. It can mean Excel is asking permission before it retrieves a value. Likewise, dismissing the prompt is not a repair: it can leave the workbook showing its previously saved values. When the source is trusted and expected, choose the appropriate update option, then verify that the result is current.

Separate link updates from formula calculation

Excel has calculation settings that determine when formulas recalculate. In the Windows desktop app, check File > Options > Formulas and look at Calculation options. Automatic is generally appropriate for ordinary workbooks. If calculation is set to Manual, changing a source or refreshing a link may not update every dependent formula until recalculation occurs. Press F9 to recalculate open workbooks, or use the calculation commands on the Formulas tab. On a Mac, check Excel > Settings (or Preferences in some releases) > Calculation; menu names can differ slightly by version.

Manual calculation can be intentional in a large workbook because it avoids repeated recalculation while users make many edits. It is not, however, a substitute for refreshing the external link itself. If the source value has not been retrieved, recalculating the destination cannot make Excel fetch it. Conversely, if the linked value is current but a dependent total is stale, recalculation is a sensible next step.

Check whether the displayed value is actually a formula result. A cell may contain a value pasted from another workbook rather than a live link. Select it and inspect the formula bar: a reference to another workbook indicates a formula link, while a fixed number or text value will not update when the source changes. If the formula was replaced by a pasted value, you must recreate the reference or use another data-import method.

Know whether you have a workbook link or a query

Power Query imports and transforms data; it does not behave like a cell-by-cell external formula reference. For a query, use Data > Refresh All or open Data > Queries & Connections and refresh the relevant query. A refresh can fail because a file path changed, a credential expired, a privacy setting blocks the combination of sources, or the source data is unavailable. The query’s source and error details are more useful than the Workbook Links pane for diagnosing those problems.

Connections can also feed PivotTables or other workbook features. Refreshing a PivotTable may update its view of data already loaded into the workbook, while refreshing its underlying connection may be needed to retrieve new records. If the workbook has several types of data, Data > Refresh All can be a useful first check, but it may take longer and can trigger multiple connections. For a targeted diagnosis, refresh one connection at a time and note which one fails.

Excel for Mac and Excel for the web can have different controls or limitations depending on the feature and release. If a workbook-link or connection command is missing, try the current desktop version of Excel and check whether the file is in a supported format. The fact that a cell displays an old value in a browser does not by itself establish whether the link is broken; the desktop app may provide the management tools needed to inspect it.

Common causes and what they usually mean

  • The old value remains after opening: Excel may not have been allowed to update links, or the source was unreachable at that time. Inspect the link and refresh it explicitly.
  • Excel reports that it cannot find the source: The file may have moved or been renamed, or the saved path may not be available on this computer. Change the source to the correct file.
  • The source is open but values still look old: Save changes in the source first, then refresh the destination. Also confirm that the destination points to that exact source file rather than another copy.
  • Some cells update but others do not: The workbook may contain links to multiple source files, or some cells may be fixed values rather than formulas. Inspect the individual references and sources.
  • A query reports an error: Treat it as a connection or query problem, not necessarily a workbook-link problem. Check the query source, credentials, and refresh error.

Another common misconception is that changing a file’s name in Windows automatically rewrites every reference in every workbook. Excel can update references in some situations when files are open together, but you should not rely on that behavior after files have been moved independently. Use the link-management tools to verify the saved source and check the resulting values.

Repair carefully and prevent repeat failures

Before changing sources, breaking links, or running any repair process, save a separate copy of the destination workbook. Breaking a link can replace formulas with their current values, removing the live connection; it is not a refresh. Once that happens, the destination will no longer follow future changes in the source unless you recreate the formulas or import the data again.

To make recurring links more dependable, keep source workbooks in a stable shared location, avoid creating multiple same-named copies, and agree on who can rename or reorganize the files. Store linked files in a team location with appropriate access rather than on an employee’s local desktop. If a workbook is intended to be a recurring report, document its source files and refresh steps so another person can identify the right link when it breaks.

If you no longer need a live connection, consider replacing the linked data with a controlled import or a clearly dated static snapshot. A static copy will not silently change when its source changes, but it also will not stay current automatically. Choose based on the task: live formulas suit a small number of values that must follow another workbook, while Power Query is often more suitable for repeatable imports and transformations. Either way, label the source and refresh date so readers can judge how current the data is.

Frequently Asked Questions

Why does Excel show the old value even after I open the source workbook?
Opening the source alone does not always refresh the destination. Save the source, switch to the destination, and use Data > Workbook Links to refresh. Confirm the destination points to the same source file you opened.

How do I force Excel to update links?
In Microsoft 365 for Windows, open Data > Workbook Links and refresh the relevant link. If dependent formulas remain stale, check that calculation is Automatic or recalculate with F9. Older builds may use Data > Edit Links.

Why can Excel not find my linked workbook?
The source may have been moved, renamed, deleted, or made unavailable by a network or cloud-sync issue. Use the link-management pane to change the source to the correct workbook, then refresh and verify the result.

Does Refresh All update links to other workbooks?
Refresh All is mainly useful for workbook connections and queries, and what it refreshes depends on the workbook’s contents. For a formula link to another workbook, inspect Data > Workbook Links and refresh that link directly.

Can I stop Excel from asking to update links?
You may be able to adjust link-update behavior, but suppressing a prompt can leave you with old values or weaken a useful security check. First verify that the source is trusted and accessible; in a work-managed environment, ask the administrator before changing external-content settings.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.