If Excel workbook links are not updating, check the link in Data > Workbook Links and choose Refresh, then confirm the source workbook is available and that calculation is set to Automatic under Formulas > Calculation Options. These checks address the most common causes; the right fix depends on whether you have a broken file path, blocked update permission, or a calculation issue.
What Excel workbook links do
An external workbook link connects a formula in one workbook to a cell or range in another. For example, a summary workbook might refer to a total in a separate monthly sales file. Excel can display the last value it retrieved even when it cannot reach the source file now, so a visible number is not proof that the link is current.
A linked formula typically includes the source workbook name and the sheet and cell being referenced. The formula bar may show a reference such as ='[Sales2025.xlsx]January'!$B$4. The precise reference can include a folder path, especially when the source workbook is closed. If the source file is moved, renamed, or no longer accessible, Excel may be unable to retrieve a new value.
Workbook links are not the same thing as Power Query connections, connections to databases, or PivotTable data sources. Those usually use refresh controls such as Data > Refresh All. A workbook formula link is managed through Workbook Links in current Microsoft 365 for Windows. Identifying the type of connection first prevents refreshing the wrong thing.
Check the source file and its path
Start by confirming that the source workbook exists and that you can open it. Check that its name, extension, folder, and sheet name have not changed. A link that once pointed to a file on a colleague’s computer or a removable drive can fail when that location is unavailable. A synced OneDrive or SharePoint location can also be inaccessible if you are signed out, lack permission, or the file has not finished syncing.
In Excel for Microsoft 365 on Windows, open Data > Workbook Links. Select the relevant source to inspect available actions and its status. If Excel identifies a problem or offers to change the source, use the correct replacement file rather than guessing at a path. If the source has moved, browse to its new location and update the link. Avoid changing the source to a similarly named workbook unless you have verified that it contains the intended data.
When several files are involved, a stable shared folder structure helps. Keeping the linked workbooks together in a team location is usually easier to maintain than linking to personal desktop folders. Moving or renaming the files later can still require relinking, and shared access does not guarantee every collaborator has the same permissions.
Refresh links and allow external updates
With the source available, use Data > Workbook Links and refresh the relevant link. Excel’s wording and the buttons shown can vary with the workbook and Microsoft 365 build; select the source in the pane and use its refresh or update action where available. If Excel asks whether to update links when you open a file, choose to update only when you trust the workbook and expect its sources to be current.
Excel may suppress automatic updates for security reasons. To review the setting in Microsoft 365 for Windows, go to File > Options > Trust Center > Trust Center Settings > External Content and look for the security settings for Workbook Links. Depending on the available choices and your organization’s policies, Excel can prompt before updating, allow automatic updates, or disable them. Do not enable automatic updating globally just to fix one workbook: links can retrieve content from files you did not intend to trust.
If your workplace manages Trust Center settings, a control may be unavailable or reset by an administrator. In that case, ask your IT team about the approved way to update the source. On Excel for Mac or Excel for the web, the Windows Trust Center path does not apply; the interface and available link-management options differ. Use the link controls available in that version, or open the workbook in desktop Excel for Windows if the needed control is not present.
Separate link updates from formula recalculation
A link can be refreshed successfully while a formula still appears unchanged, or a formula can recalculate using an old cached link value. These are separate processes: updating retrieves values from the source workbook, while calculation evaluates formulas in the workbook you have open.
In Excel for Windows, check Formulas > Calculation Options and select Automatic if the workbook should calculate as you edit. If calculation is set to Manual, formulas may not update until you request calculation. Press F9 to calculate open workbooks; Ctrl+Alt+F9 forces a full calculation of formulas in open workbooks. These shortcuts recalculate formulas but do not, by themselves, repair a missing source file or grant permission to update a link.
Calculation mode can affect more than one open workbook. If an older workbook was opened first and uses Manual calculation, Excel may retain that mode for other workbooks in the session. Check the setting again after opening the affected file. On Mac, the ribbon and shortcut behavior can differ, so use Formulas > Calculation Options and the available calculation commands for your Excel version rather than assuming Windows keystrokes apply.
Diagnose common errors and stale values
The symptom often points toward the right cause. A message that Excel cannot find a source usually indicates an unavailable or changed path. A prompt about updating links indicates that Excel has found an external reference but needs a decision or permission. An unchanged result with no visible error may be a cached value, manual calculation, or a source cell whose value has not actually changed.
- Source cannot be found: Check the filename and location, then use Workbook Links to select the correct replacement source.
- Update prompt appears repeatedly: Review the source status and external-content security settings. A prompt is not necessarily an error; it may be Excel asking whether to trust and retrieve external values.
- Some formulas update but others do not: Inspect the formulas for references to different files or sheets. A workbook can contain multiple links, and one working link does not confirm that all sources are available.
- The displayed value looks old: Open the source workbook and check the referenced cell. Then refresh the link and recalculate the destination workbook.
- Excel shows an error after a sheet was renamed: Check whether the source reference still points to an existing sheet and cell. Correct the reference using the actual source structure.
Do not treat every number that fails to change as proof that Excel is broken. The source cell might still contain the same value, or the destination formula may refer to a different cell than expected. Click the destination cell and inspect the formula bar before altering the link.
Find links that are not obvious
Workbook Links is the best starting point for standard external workbook formulas, but a workbook can contain references in places that are less visible. Search formulas for the opening square bracket used in many external references, and inspect named ranges through Formulas > Name Manager. Defined names can refer to an external workbook even when no obvious cell on the current sheet does.
Also check charts, data validation, conditional formatting, and objects if a particular visual or dropdown appears stale. Those features can have their own references or depend on cells that are linked elsewhere. If a workbook was copied from another file, inspect formulas and names before assuming all references were updated to the new source. A search is a diagnostic aid, not a guarantee that every kind of connection has been found.
When to change or remove a link
If the source workbook has been permanently replaced, update the link to the authoritative replacement. If you no longer need live values, you can break a workbook link through the Workbook Links controls where that action is available. Breaking a link typically replaces linked formulas with their current values, so those cells will no longer change when the source changes. This is a one-way loss of the formula connection, not a way to repair it.
Before changing or breaking links, save a separate copy of the workbook. Confirm which file is the trusted source, check important totals after the change, and tell collaborators if the workbook will stop receiving live updates. If you need a repeatable import and transformation process rather than cell-by-cell formulas, Power Query may be an alternative, but it has its own connection and refresh settings and is not interchangeable with a workbook formula link.
Prevent the problem from returning
Most recurring link failures come from unstable locations, unclear ownership, or assumptions about who can access the source. A small amount of housekeeping makes workbooks easier to share and audit:
- Keep source and destination files in an agreed team location, and avoid changing filenames or folder structures without notifying users.
- Document which workbook is authoritative and which sheets or values the destination depends on.
- Check link status and key results after moving a workbook, copying it, or changing a source file.
- Use refresh prompts thoughtfully. Allow updates only when the source and its location are expected and trusted.
- For critical reports, compare important output values with the source after updating rather than relying only on the absence of an error message.
These practices matter particularly when files are shared with people who have different drive mappings, accounts, or permissions. A link that works on one computer may still fail for someone whose access or sync setup differs.
Frequently Asked Questions
Why are my Excel links not updating automatically?
Excel may be set to prompt or block external workbook updates, the source may be unavailable, or calculation may be set to Manual. Check Data > Workbook Links, confirm access to the source, and review Formulas > Calculation Options.
Does Refresh All update links to other Excel workbooks?
Refresh All is commonly used for queries and other data connections. For standard formulas linked to another workbook, use the Workbook Links controls. First identify whether the stale result comes from a formula link or a query.
Why does Excel show an old value when the source workbook is closed?
Excel can display the last value stored with the destination workbook when it cannot retrieve a current value. Check that the source is reachable, update the link, and verify the referenced source cell.
Will breaking a workbook link stop the value from changing?
Yes. Breaking a link generally replaces linked formulas with their current displayed values. The cells no longer receive changes from the source, so save a backup and verify the results before doing it.
Can I fix links when the source file has been renamed?
Usually, if you can identify the correct replacement file. In Data > Workbook Links, select the affected source and use the option to change or locate it. Check the resulting values because a similarly named file may contain different data.
Related
- Power Query Split Cell Into Rows: Steps and Examples
- Power Query Editor: How to Split Text into Multiple Columns
- Power Query Union Tables: How to Append Queries
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Not Responding After Copy and Paste? Fix ItIf Excel says “Not Responding” after you copy and paste, first give it a little time: a large…
- Outlook Share Calendar Button Not Working? How to FixIf Outlook’s Share Calendar button is missing, disabled, or does nothing, first check that you are using a…
- Fix a Broken Workbook Link in ExcelTo fix a broken workbook link in Excel for Microsoft 365 on Windows, open the workbook that contains…
- Excel Circular Reference: How to Find and Fix ItIn Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References, then select…
- Excel Not Working on iPad? Fixes for Common ProblemsIf Excel is not working on your iPad, check your internet connection and Microsoft account, update Excel and…
- SUMIFS Excel Formula Not Working? Fix the CauseIf SUMIFS is not working, first check its argument order, matching range sizes, and criteria: Excel expects =SUMIFS(sum_range,criteria_range1,criteria1,...),…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.