How to Fix ‘We Can’t Update Some of the Links in Your Workbook’ in Excel

Opening an analytical model, quarterly financial summary, or inventory spreadsheet in Microsoft Excel only to be greeted by the prompt “We can’t update some of the links in your workbook right now. You can continue without updating them, or edit the links you think are wrong” disrupts automated data ingestion. Excel workbooks frequently reference cells, named ranges, or structured tables located inside external workbooks. When an external source file is renamed, moved to a different directory, stored on an unmounted network share, or stored inside a synced OneDrive folder with altered cloud URLs, Excel’s calculation engine cannot refresh linked cell values. This technical troubleshooting guide explains how Excel manages external data references and details step-by-step methods to locate, update, or permanently break broken links in your workbooks.

Why Does Excel Fail to Update External Links?

External link errors occur when formula pointers lose their connection to external files. Common triggers include:

  • Moved, Renamed, or Deleted Source Workbooks: The referenced workbook was relocated to another folder, renamed, or deleted, leaving an invalid absolute file path in formula definitions.
  • OneDrive / SharePoint Cloud URL Desynchronisation: When files are moved between local sync folders and SharePoint document libraries, absolute web URLs (HTTPS) can conflict with mapped local paths.
  • Hidden Links in Charts, Pivot Tables, or Conditional Formatting: External references hidden inside chart series formulas, data validation rules, or shape definitions that do not appear in regular cell formulas.
  • Unmounted Corporate Network Drives: References pointing to mapped letters (e.g. Z:\Finance\2026.xlsx) when the network drive is disconnected.
  • Defined Names Referencing External Sources: Corrupted named ranges inside Name Manager pointing to non-existent workbooks.

Method 1: Audit and Change Source Files in Edit Links

Excel’s built-in link manager allows you to inspect the health of all external workbook connections and remap moved files.

  1. Open the problematic workbook in Microsoft Excel.
  2. Click on the Data tab on the Ribbon.
  3. In the Queries & Connections group, click Edit Links (if this button is greyed out, your workbook contains no formal workbook links).
  4. In the Edit Links dialogue, review the list of source files:
    • Look at the Status column. Files marked with Error: Source not found or Unknown have broken paths.
  5. Click the Check Status button to refresh connection tests.
  6. Select the broken source file and click Change Source….
  7. Navigate to the new folder location of the source workbook, select it, and click OK. Excel will instantly update all formulas pointing to the old path.

Method 2: Permanently Break Orphaned External Links

If the source workbook is no longer available and you want to freeze existing values into permanent static numbers, breaking the link removes the warning.

  1. Go to Data > Edit Links.
  2. Select the broken external file from the list.
  3. Click the Break Link button on the right-hand side.
  4. A confirmation prompt will warn you that breaking links permanently converts external formulas into their current static values.
  5. Click Break Links.
  6. Save the workbook (Ctrl + S), close it, and reopen it. The startup warning prompt will no longer appear.

Method 3: Locate Hidden External Links in Defined Names

Orphaned external links frequently hide inside Excel’s Name Manager rather than visible worksheet cells.

  1. Click on the Formulas tab on the Ribbon.
  2. Click Name Manager (or press Ctrl + F3).
  3. In the Name Manager dialogue, look down the Refers To column for square brackets [...] or file paths pointing to external files (e.g., ='C:\Reports\[OldData.xlsx]Sheet1'!$A$1).
  4. Click the Filter button in the top-right corner of Name Manager and select Names with Errors.
  5. Select any damaged or external defined names and click Delete.
  6. Click Close and save your workbook.

Method 4: Search the Entire Workbook for Bracketed References

If Edit Links still reports a link that you cannot see, searching the XML cell formulas will isolate the exact cell coordinate.

  1. Press Ctrl + F to open the Find and Replace dialogue.
  2. In the Find what: field, type:
    [*.xl*]
    (This search string isolates any formula containing external workbook brackets).
  3. Click the Options >> button to expand advanced search parameters.
  4. Change the Within: dropdown from Sheet to Workbook.
  5. Change Look in: to Formulas.
  6. Click Find All.
  7. Excel will list every worksheet, cell coordinate, and formula referencing external files. Click on each result in the list to navigate to that cell and update or remove the formula.

Method 5: Check Data Validation and Conditional Formatting Rules

Data validation dropdown lists often reference lists located in external files that have since moved.

  1. Click on the Home tab on the Ribbon.
  2. In the Editing group, click Find & Select > Data Validation.
  3. Excel will highlight all cells on the active worksheet that use data validation.
  4. Go to Data > Data Validation and check if the Source: box references an external path. If so, update the range or copy the source data locally.
  5. Next, go to Home > Conditional Formatting > Manage Rules. Change Show formatting rules for: to This Worksheet, and inspect rules for external paths.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.