Excel External Links Not Updating? 11 Fixes That Work

A laptop showing a plain spreadsheet grid beside a second workbook icon shape — excel external links not updating guide
An external link reads values from another workbook, so a stale value usually means the link, the path, or a setting — not your data.

You change a number in the source workbook, open the file that links to it, and the old value is still there. When excel external links not updating strikes, reports go out with stale figures, and you cannot trust any number that came from another file. The link itself is rarely destroyed. More often Excel was told not to update, the source file moved, or the calculation setting is holding every formula still.

This guide works through the causes in order, from the update prompt you may have dismissed to a source file that no longer sits where the link expects it. Nothing here deletes your data, and the one step that cannot be undone — breaking a link — is saved for last, with a backup first. Work through the fixes one at a time, and check the linked values after each one.

Table of Contents

  • Why This Error Happens
  • Quick Checks
  • Diagnosing the Problem
  • Fix 1: Answer the Update Links Prompt and Refresh on Open
  • Fix 2: Update Values from the Workbook Links Pane
  • Fix 3: Open the Source Workbook and Recalculate
  • Fix 4: Check the Calculation Setting Is Automatic
  • Fix 5: Fix a Moved or Renamed Source with Change Source
  • Fix 6: Check Trust Center Settings for Workbook Links
  • Fix 7: Move Both Files to Trusted Locations You Control
  • Fix 8: Check Defined Names and Objects That Carry Old Links
  • Fix 9: Fix Links That Point to Closed Network or Cloud Files
  • Fix 10: Rebuild the Link with a Fresh External Reference
  • Fix 11: Break the Link and Paste Values When the Source Is Gone
  • What to Avoid
  • Frequently Asked Questions
  • Conclusion
  • Helpful Official Resources

Why This Error Happens

An external link is a formula that reads a cell in another workbook. For the value to refresh, Excel must find the source file, be allowed to read it, and be set to calculate. If any link in that chain breaks, Excel keeps the last value it managed to read — silently, with no error in the cell. These are the breaks that happen most often.

1. The Update Prompt Was Dismissed or Turned Off

When you open a workbook with external links, Excel asks whether to update them. Clicking Don’t Update keeps the old values for that session, and choosing not to be asked again can silence the prompt permanently. The links are healthy, but Excel was told not to use them. This is the cause when values update on a colleague’s computer but never on yours.

2. The Source Workbook Moved, Was Renamed, or Was Deleted

An external link stores the full path to the source file. Rename the source, move it to another folder, or delete it, and the link points at a file that no longer exists at that address. Excel keeps the last known value and shows no error in the cell, so the staleness is invisible until someone compares the numbers. Folder reorganisations and year-end file moves cause most of these breaks.

3. Calculation Is Set to Manual

Manual calculation tells Excel to update formulas only when you press F9 or ask for a recalculation. External links obey the same rule: with manual calculation on, opening the file does not refresh anything, and even an explicit update can look as if it did nothing. Manual calculation is sometimes turned on for very large workbooks and then forgotten, and it affects every open workbook, not just one file.

4. Trust Center Settings Block the Update

Excel’s Trust Center guards external content, because a link can pull data from a file you do not control. If automatic updating of workbook links is disabled, or the file sits in an untrusted location, Excel blocks the refresh and may show a security bar instead. The block is a safety feature, but it looks exactly like a broken link when you do not know it is there.

5. The Source File Is Closed, Offline, or on an Unreachable Drive

Excel can read values from a closed source workbook, but only if the file is reachable. A source on a network drive that is not connected, a cloud folder that has not synced, or a USB drive that is unplugged cannot be read at all. The link keeps its last value and waits. This cause comes and goes with the connection, which makes it look intermittent and hard to pin down.

6. The Link Lives in a Defined Name, Object, or Chart — Not a Cell

Not every external link sits in a cell formula. Defined names, text boxes, shapes, chart titles, and chart data series can all carry links to other workbooks. The Workbook Links pane lists the source, but the cell formulas look clean, so the usual checks find nothing. These hidden links explain workbooks that keep asking to update even after every visible formula has been checked.

Quick Checks

Two minutes before the deep fixes.

  • Close and reopen the workbook — does Excel ask whether to update links?
  • Open the source workbook — does it open, and does it hold the new value?
  • Press F9 — do the linked values change?
  • Check Formulas, then Calculation Options — is it set to Automatic?
  • Check whether the source file was moved or renamed recently.
  • Check whether the source sits on a network drive, a cloud folder, or a USB drive that is currently disconnected.

Diagnosing the Problem

SymptomCauseGo to Fix
No update prompt on openPrompt dismissed or refresh set to neverFix 1
Prompt appears but values stay oldLink needs a manual updateFix 2
Values update only when source is openSource path or trust issueFix 3
Nothing recalculates at allManual calculation is onFix 4
Source file moved or renamedLink points at the old pathFix 5
Security bar appears on openTrust Center blocking the updateFix 6
Link source not in any formulaLink hidden in a name or objectFix 8
Values update sometimes, not alwaysSource drive or cloud sync offlineFix 9

Fix 1: Answer the Update Links Prompt and Refresh on Open

The simplest cause is the simplest fix. Excel asks about links when the file opens, and the answer you give decides the whole session. If the prompt was dismissed, or the workbook is set never to refresh, reopening the file and answering correctly restores updates in seconds.

A laptop showing a spreadsheet with a plain dialog box shape on screen — excel external links not updating guide
The update prompt decides the whole session — answering it correctly is the fastest fix of all.
  1. Close the destination workbook without saving changes you do not need.
  2. Reopen the workbook and watch for the links warning dialog.
  3. Click Update when Excel asks whether to update the links.
  4. Wait for the update to finish, then check the linked cells.
  5. If no prompt appears, open Data, then Queries & Connections, then Workbook Links.
  6. Expand Refresh settings and choose Ask to refresh or Always refresh.
  7. Close and reopen the workbook, then check the values again.
  • Choosing Don’t refresh in the refresh settings is the silent killer: Excel neither updates nor asks, so nobody knows the data is stale. Ask to refresh is the safe default — it prompts every time, so you decide with full knowledge.
  • Always refresh suits workbooks whose sources you fully trust and that update every day.
  • If the prompt appears but the values still do not change, the link needs a manual push, which Fix 2 provides.

Fix 2: Update Values from the Workbook Links Pane

The Workbook Links pane is the control centre for every external link in the file. It lists each source workbook, lets you refresh one link or all of them, and shows the status of each. A manual refresh from here bypasses the startup prompt entirely, so it proves whether the links themselves work.

  1. Open the destination workbook.
  2. Click Data, then Queries & Connections, then Workbook Links.
  3. Read the list of source workbooks and their status.
  4. Select one source workbook and click Refresh.
  5. Check the cells linked to that source for new values.
  6. Click Refresh all at the top of the pane to update every link.
  7. Check all linked cells, then close the pane.
  • If a single link refreshes but others do not, the failing sources need individual attention — note which ones fail and take them to Fix 5. If the pane is empty, the workbook may hold no workbook links at all, and the stale values come from somewhere else, such as a defined name covered in Fix 8.
  • Older Excel versions show the legacy Edit Links dialog instead, with an Update Values button that does the same job.
  • A refresh that works here proves the paths and permissions are fine, and the fault was the startup setting in Fix 1.

Fix 3: Open the Source Workbook and Recalculate

Excel reads linked values most reliably when the source workbook is open. Opening the source also lets you confirm the new value actually exists — sometimes the “stale” link is correct, and the source was never updated. Test with the source open before you rebuild anything.

  1. Note the source workbook name from the Workbook Links pane.
  2. Open the source workbook from its current location.
  3. Find the linked cell and confirm it holds the new value.
  4. Save the source workbook if you changed anything in it.
  5. Switch back to the destination workbook.
  6. Press F9 to recalculate, or click Formulas, then Calculate Now.
  7. Check the linked cells for the new value.
  • If the values update with the source open but not with it closed, the path Excel stores for the closed file is the problem — Fix 5 repairs it. If the values do not update even with the source open, calculation itself is held still, which Fix 4 checks.
  • Keep both files open while you test, and save the source before you judge the destination — an unsaved change in the source cannot be read by any link.
  • This test also catches the embarrassment of chasing a link fault when the source simply was never edited.

Fix 4: Check the Calculation Setting Is Automatic

Manual calculation stops every formula from updating, including external links. It is a common leftover from working with a very large workbook, and because it applies to the whole Excel application, it affects every file you open. Switching back to automatic restores updates everywhere at once.

  1. Click the Formulas tab on the ribbon.
  2. Click Calculation Options in the Calculation group.
  3. Read which option is selected: Automatic, Automatic Except for Data Tables, or Manual.
  4. If Manual is selected, click Automatic.
  5. Press F9 to force a full recalculation of the workbook.
  6. Check the linked cells for the new values.
  7. Reopen the workbook and confirm the values update on open.
  • Automatic Except for Data Tables is fine for most workbooks — it only holds back data-table recalculation. If you need manual calculation for a genuinely huge workbook, remember to press F9 after every change, and warn anyone else who uses the file.
  • Calculation settings travel with the application session, so a colleague opening the same file on another computer may see different behaviour — that difference points straight at this setting.
  • When pivot tables in the same file also show old numbers, our guide to Excel pivot table not refreshing covers the refresh steps for pivot data.

Fix 5: Fix a Moved or Renamed Source with Change Source

When the source file moves or is renamed, the link keeps pointing at the old address. Change Source repoints every reference to that source in one step, without editing formulas one by one. It is the correct repair for folder reorganisations, year-end moves, and renamed files.

  1. Open the destination workbook and the Workbook Links pane.
  2. Find the source workbook in the list.
  3. Click the More Commands button beside it, then Change source.
  4. Browse to the source workbook in its new location.
  5. Select the file and click OK.
  6. If asked, choose the correct worksheet and click OK.
  7. Check the linked cells, then save the destination workbook.
  • Change the source for all references at once — editing individual formulas to the new path leaves stragglers that fail later. If the source was renamed, browse to the renamed file; if it was moved, browse to the new folder.
  • After the change, the status in the pane should show the link as healthy. Keep the old and new locations in mind: if the file moves again, you will repeat this step, so settle on a stable home for shared source files.
  • When excel external links not updating follows a file move, this fix is almost always the whole answer.

Fix 6: Check Trust Center Settings for Workbook Links

The Trust Center can block automatic link updates for safety. The default asks you each time, which is safe and visible. But if the setting was changed to disable automatic updates, links never refresh and no prompt explains why. Checking the setting takes a minute and restores the prompt.

A laptop showing a plain settings screen with rows and toggles — excel external links not updating guide
Trust Center settings decide whether Excel may refresh links automatically — a disabled setting looks exactly like a broken link.
  1. Click File, then Options, then Trust Center.
  2. Click Trust Center Settings, then External Content on the left.
  3. Read the option selected under Security settings for Workbook Links.
  4. If Disable automatic update of Workbook Links is selected, change it.
  5. Choose Prompt user on automatic update for Workbook Links — the safe default.
  6. Click OK twice to save, then close and reopen the destination workbook.
  7. Click Update on the prompt and check the linked values.
  • Do not choose the “enable all” option for files you do not trust — the prompt exists because links can pull data from files outside your control. In an organisation, an administrator may control these settings, in which case the options are greyed out and you need to ask your IT support.
  • The prompt setting also explains why links update on one computer and not another: each computer keeps its own Trust Center choices.
  • If the file opens with a security bar instead of the link prompt, the location trust in Fix 7 is the next check.

Fix 7: Move Both Files to Trusted Locations You Control

Files in trusted locations open without security blocks, and their links update without a fight. A file downloaded from email or the internet, or sitting in a temporary folder, is treated with suspicion. Moving both the source and the destination to folders you control — and adding those folders as trusted locations — removes the block at its root.

  1. Decide on a stable folder for the source workbook, such as a project folder.
  2. Move the source workbook there, then fix the link with Fix 5 if the path changed.
  3. Move the destination workbook to the same project folder if practical.
  4. Click File, then Options, then Trust Center, then Trust Center Settings.
  5. Click Trusted Locations and then Add new location.
  6. Browse to the project folder, tick Subfolders if you use them, and click OK.
  7. Close and reopen the destination workbook and check the linked values.
  • Trusted locations are powerful, so add only folders you control — never a shared download folder or a removable drive that other people write to. Keeping the source and destination in the same folder also makes relative paths work: if the whole folder moves together, the links survive.
  • If the workbook opens in Protected View with a yellow bar, our guide to Excel file opens in Protected View explains the trust steps for downloaded files.
  • A trusted location that covers both files ends a whole class of “sometimes updates” faults.

Fix 8: Check Defined Names and Objects That Carry Old Links

When the Workbook Links pane lists a source but no cell formula mentions it, the link hides in a defined name, a text box, a shape, a chart title, or a chart data series. Each hiding place needs its own check, and the Find command with a file-pattern search finds the formula links fastest.

  1. Press Ctrl+F, click Options, and set Within to Workbook and Look in to Formulas.
  2. Search for the source file pattern and click Find All to list every match.
  3. Click each result to jump to the cell and check its formula.
  4. Open Formulas, then Name Manager, and check the Refers To column for the source name.
  5. Edit or delete any defined name that points at the old source path.
  6. Press Ctrl+G, click Special, choose Objects, and tab through shapes checking the formula bar.
  7. Click each chart title and data series and check the formula bar for the source name.
  • Names copied in from other workbooks are the most common hiding place, and they can keep a workbook asking to update long after every visible formula is clean. Delete a suspect name only after noting its definition, so you can restore it if something needs it.
  • Objects and charts need the same care: a chart title linked to a moved source keeps the old value and the old prompt.
  • When the Workbook Links pane shows no sources at all after this cleanup, the hidden links are gone, and the workbook should open without asking.

Fix 9: Fix Links That Point to Closed Network or Cloud Files

A source on a network drive, a cloud folder, or a USB drive is only readable while that storage is connected and synced. Excel cannot update from a drive that is not mapped, a cloud file that has not downloaded, or a USB stick that is unplugged. The fix is to restore the connection — or to move the source somewhere reliably reachable.

  1. Check whether the source drive or folder is currently reachable in File Explorer.
  2. If a network drive is disconnected, reconnect it and reopen the destination workbook.
  3. If the source is in a cloud folder, open the folder and confirm the file has synced.
  4. If the source is on a USB drive, plug the drive in and confirm its letter matches the link.
  5. Reopen the destination workbook and click Update on the prompt.
  6. If the storage is unreliable, copy the source to a stable local folder.
  7. Repoint the link with Change Source (Fix 5) and save the destination.
  • Cloud sync adds a subtle trap: a file that shows in the folder may still be an online-only placeholder that has not downloaded. Open the source file itself to force the download, then refresh the destination.
  • Mapped drive letters can change too — a link to drive Z fails when the drive remaps to Y, so prefer full network paths for shared sources where your setup allows. If a workbook opens to a blank screen after storage changes, our guide to Excel workbook opens blank covers the display-side recovery.
  • Stable storage for the source file prevents this whole fix from being needed again.

Fix 10: Rebuild the Link with a Fresh External Reference

When a link is damaged in a way no setting can repair, rebuilding it from scratch is cleaner than patching it. A fresh external reference, created by pointing at the source cell with the mouse, carries the correct path, the correct sheet name, and the correct cell — with no leftover damage from the old link.

Two laptops side by side showing spreadsheets, with a notebook between them — excel external links not updating guide
Rebuilding a link by pointing at the source cell creates a clean reference with the correct path.
  1. Open both the source and destination workbooks.
  2. In the destination, select the cell that should hold the link.
  3. Type = to start the formula.
  4. Switch to the source workbook and click the cell with the value.
  5. Press Enter to complete the formula and return to the destination.
  6. Check the formula bar shows the full path, sheet name, and cell.
  7. Save the destination workbook and reopen it to confirm the link updates.
  • Building the reference with the mouse avoids typing errors in paths, sheet names, and brackets — the mistakes that break hand-typed links. Rebuild one link first and test it thoroughly before rebuilding the rest, so a path problem shows up once instead of twenty times.
  • If the source sheet name contains spaces, Excel adds the quotes automatically when you click; hand-typing the same reference often forgets them.
  • A rebuilt link that updates on open proves the old link was damaged, not the file or the settings.

Fix 11: Break the Link and Paste Values When the Source Is Gone

When the source workbook is deleted, retired, or no longer available, no fix can restore updates — there is nothing left to update from. Breaking the link converts every linked formula to its current value, so the workbook keeps its numbers and stops asking. This step cannot be undone, so back the file up first.

A laptop showing a clean spreadsheet with a backup drive beside it — excel external links not updating guide
Breaking a link keeps the last values but ends the connection, so always keep a backup copy first.
  1. Save a backup copy of the destination workbook with a clear name.
  2. Open the Workbook Links pane from Data, then Queries & Connections.
  3. Select the source workbook whose file is gone.
  4. Click More Commands beside it, then Break links.
  5. Confirm the break when Excel warns that the action cannot be undone.
  6. Check that the linked cells now show plain values, not formulas.
  7. Save the workbook and reopen it to confirm no update prompt appears.
  • Breaking a link replaces each formula with the value it last read, so the numbers stay but the connection is gone forever. If you only need to freeze some cells, copy them and use Paste Special, then Values, instead — that keeps the other links alive.
  • Check defined names afterwards, because a name that pointed at the broken source may still ask for it. If filters in the same workbook also misbehave after link changes, our guide to Excel filter dropdown not working covers the filter-side checks.
  • A clean break, with a backup kept, is a better ending than a workbook that asks about a dead file forever.

What to Avoid

  • Do not choose Don’t refresh for links you rely on — Excel will neither update nor warn you that the data is stale.
  • Do not break a link without a backup — the action cannot be undone, and the formulas are gone for good.
  • Do not enable all external content for untrusted files — use the prompt setting and trusted locations for folders you control.
  • Do not hand-type external references with paths and brackets — point at the source cell so Excel builds the reference correctly.
  • Do not rename or move a source file without repointing its links — every destination file keeps the old address.
  • Do not use pirated software, activators, or cracks — they can damage Office and invite malware into your workbooks.
  • Do not install a “link repair” tool from an unknown source — use the Workbook Links pane and Change Source built into Excel.

Frequently Asked Questions

Why do my links update on one computer but not another?

Because the update behaviour lives in settings on each computer: the startup prompt choice, the Trust Center setting, and the calculation mode. A computer set to Don’t refresh, or with automatic updates disabled, keeps old values while another computer updates happily. Compare the settings in Fixes 1, 4, and 6 across the two computers.

Can Excel update links when the source workbook is closed?

Yes, if the source file is reachable at the stored path. Excel reads the saved values from the closed file without opening it on screen. It cannot read a file that moved, was renamed, or sits on disconnected storage — in those cases the link keeps its last value until the path or the connection is repaired.

Why does Excel keep asking to update links I cannot find?

The links hide in defined names, objects, shapes, chart titles, or chart data series, not in cell formulas. Use the Find search and the Name Manager checks in Fix 8 to locate them. Until every hiding place is cleaned, Excel keeps asking, because a real link still exists somewhere in the file.

What is the excel external links not updating fix when the source is on a shared drive?

First confirm the shared drive is connected and the file opens from it, then use Change Source to repoint the link at the full network path rather than a drive letter that can change. If the drive is unreliable, copy the source to a stable folder and repoint the link there. Test by closing and reopening the destination and answering Update on the prompt.

Will breaking a link delete my numbers?

No. Breaking a link converts each linked formula into the value it last read, so the numbers stay exactly as they were. What disappears is the connection: future changes in the source will no longer flow through. Keep a backup before breaking, because the formulas themselves cannot be restored afterwards.

Why do links show old values after I saved the source?

Usually because the destination was open with manual calculation on, or because the update prompt was dismissed for that session. Press F9 to recalculate, or close and reopen the destination and click Update. If the values still lag, check the Workbook Links pane status — the stored path may point at an older copy of the source in a different folder.

Conclusion

When excel external links not updating leaves your workbook showing yesterday’s numbers, the fault is usually a dismissed prompt, manual calculation, a blocked trust setting, or a source file that moved. Answer the prompt correctly, refresh from the Workbook Links pane, check the calculation and trust settings, and repoint any link whose source has a new home. Finish by closing and reopening the file and watching the values update on their own, because a clean open is the only proof that counts. Keep source files in stable, trusted folders, and your links will stay fresh without a second thought.

Helpful Official Resources

Leave a Reply

Your email address will not be published. Required fields are marked *