Excel Workbook Link Broken? How to Fix It

Errors & fixes · Updated November 19, 2026

If an Excel workbook link is broken, first identify whether you mean an external-workbook reference in a formula or a clickable hyperlink: they are repaired in different places. For a broken formula link in Microsoft 365 for Windows, open Data > Workbook Links, select the source, and use Change source or Refresh if those options are available; for a clickable link, right-click it and choose Edit Hyperlink.

Identify which kind of link has failed

Excel uses the word link for several different things. A cell can contain a formula that gets a value from another workbook, or it can contain a hyperlink that opens a file, webpage, or place in a workbook. A workbook can also use a data connection to import information from an external source. The visible symptom helps narrow down which one needs attention.

  • A formula shows #REF! or an old value: it may refer to a cell, sheet, or file that was moved, renamed, or deleted. An external workbook reference can include the source workbook name and a worksheet name.
  • A click opens an error page or says the file cannot be found: the cell probably contains a hyperlink whose destination is no longer valid, or the destination is inaccessible to you.
  • A query or imported table is out of date: the issue may be a data connection, sign-in, or refresh problem rather than a workbook link.
  • A file opens but displays an update prompt: Excel may be asking whether it should retrieve values from an external workbook. That prompt alone does not prove the link is broken.

Before changing anything, note the exact error and the cell or feature where it appears. If a link appears to work on one computer but not another, that is useful evidence: the destination may depend on a local folder, a network drive, or permissions that differ between users.

Repair an external workbook reference

External workbook references let formulas use data stored in another Excel file. If the source file has moved or been renamed, Excel may still be looking at its former location. In Microsoft 365 for Windows, go to Data > Workbook Links to inspect the workbook links Excel has detected. Select the relevant source and look for an option such as Change source to point the link to the correct file. If the file is already in the expected location, try Refresh to retrieve its latest values.

The available controls can depend on the workbook and Excel build. Some older desktop versions show an Edit Links command on the Data tab instead. If you do not see Workbook Links, check that you are using the desktop Excel app and look for the legacy command in your version. Excel for the web has different link-management capabilities and may not expose every desktop control; open the file in desktop Excel if you need a command that is unavailable in the browser.

When choosing a replacement source, confirm that it is the correct workbook, not merely a file with a similar name. Then check several dependent cells and sheets, especially any totals, charts, or reports that rely on the source. If Excel reports that some links cannot be updated, inspect those references separately rather than assuming that changing one source repaired every link in the file.

A missing source workbook must be restored or replaced with an appropriate file before its linked values can be refreshed. If you have a known-good copy, ask the file owner or your organization’s support team to confirm that it is the intended source. Do not point a financial or operational report at a similarly named workbook just to remove an error message.

Check paths, names, and file access

Workbook links often break because a file’s location changes. For example, a formula may have been created when the source workbook lived in a department folder on a network drive. If that folder is renamed, the drive letter changes, or the file is moved to OneDrive or SharePoint, the old reference may no longer identify the source. A colleague may also have a different local folder structure, even if both people have a copy of the same workbook.

Check these common causes before rebuilding formulas:

  • The source file was renamed or moved. Ask where the current authoritative copy is stored, then use Change source if the link-management pane offers it.
  • The source folder is unavailable. A disconnected VPN, network drive, or cloud sync can make a valid path temporarily unreachable. Restore access and try again before editing the reference.
  • You lack permission. A link cannot provide access to a file that your account is not allowed to open. Request access from the owner instead of using someone else’s sign-in.
  • The source was replaced or deleted. If the original is gone, identify a verified replacement and check that its sheet names and data structure match what the formulas expect.
  • A sheet or cell was deleted. A #REF! error can result from a broken reference inside the workbook itself, even when no external file is involved.

If the source is on SharePoint or OneDrive, make sure you are signed in to the account that has access and that the file is available at its current shared location. A sharing link copied from a browser is not always the same thing as a stable source path for an Excel formula. If multiple people depend on the workbook, use an agreed location and ask the owner to confirm which file should be treated as the source of truth.

Fix a clickable hyperlink

A hyperlink is a destination attached to a cell or object. It can fail even when the workbook’s formulas are fine. In Excel for Microsoft 365 on Windows, right-click the linked cell and choose Edit Hyperlink. Review the address or file path in the dialog, correct it, and confirm the change. You can also select the cell and press Ctrl+K to open the hyperlink dialog. On Mac, use Command+K; the context menu may appear after Control-clicking or right-clicking, depending on your mouse or trackpad settings.

Test the destination outside the workbook if you are unsure whether it still exists. For a local file, check that the file is present and that you can open it. For a webpage, confirm the address in a browser. For a shared file, verify that the recipient has permission; a link that works for its creator may not work for another person. If the hyperlink points to a worksheet location, check that the named sheet still exists and has not been renamed.

When replacing many hyperlinks, be careful not to overwrite useful labels or other cell content. A link’s displayed text can look correct while its underlying destination is stale, so simply reading the cell is not enough. Test a sample of repaired links and, if the workbook is important, keep an untouched copy before making a large set of edits.

Distinguish link errors from refresh and security prompts

An external reference and an imported data connection are separate mechanisms. A formula can read a value from another workbook, while a query or connection can retrieve data from a database, file, or online service. Updating one does not necessarily update the other. If the displayed data comes from a query, check the workbook’s query or connection refresh controls and any sign-in requirements rather than changing an unrelated formula link.

Excel may also warn that external content could be unsafe. Treat that warning as a security decision, not as a repair instruction. Only update or enable content when you recognize the source and trust the file’s origin. A prompt to update links can expose the workbook to current values from an external source, but it does not establish that the source is accurate or safe. If the file arrived unexpectedly, ask the sender what the links are for before allowing updates.

Cached values can make a workbook appear complete even when its source is unavailable. Those values may be the last results Excel saved; they are not proof that the link can currently refresh. If a report depends on current data, confirm the update time and compare key values with the authorized source before relying on it.

Find hidden or overlooked references

When the Workbook Links pane does not explain the problem, search for other references. In Excel for Windows, press Ctrl+F, select Options if necessary, set Look in to Formulas, and search for an opening square bracket. External workbook references commonly include the source workbook name in square brackets, so this can reveal formulas that point outside the current file. Search results are clues, not a complete inventory: names, charts, and other workbook features can also contain references.

Use Formulas > Name Manager to review defined names. A name may refer to a range in another workbook or to a cell that has since been deleted. Inspect charts, data validation, and other features that depend on ranges if a workbook still behaves unexpectedly after its obvious formulas have been repaired. For a data import, check the query and connection settings rather than expecting a formula search to reveal the source.

Make one repair at a time and recalculate or refresh the relevant area, then review the results. If you are unsure what a reference feeds, do not delete it just because its path looks unfamiliar. It may support a report, chart, or process used elsewhere in the workbook.

Prevent links from breaking again

Workbooks shared among a team are less fragile when their source files stay in a stable, agreed location. Avoid building shared processes around a personal Downloads folder, a temporary desktop folder, or a drive letter that only some users have. A team folder with consistent permissions is usually easier to maintain, although access still needs to be granted to each intended user.

  • Keep the source workbook’s name and folder stable, and tell users before reorganizing shared files.
  • Document which file is authoritative and who owns it, especially when similar copies circulate by email.
  • Test links under the account and device conditions used by the people who will rely on the workbook.
  • Prefer a maintained data-import process when the task is to refresh structured data, rather than relying on many manually copied values.
  • Before distributing a workbook, decide whether recipients need live links or a fixed snapshot. If a fixed snapshot is appropriate, confirm the consequences before removing links.

There is no universally best choice between a live link and a static copy. A live reference can keep related workbooks connected, but it depends on an available source and appropriate permissions. A static copy is easier to open independently, but it will not automatically reflect later changes. Choose based on whether ongoing updates or a self-contained record matters more, and communicate that choice to users.

Frequently Asked Questions

Why does Excel say it cannot update links?
Excel may be unable to reach the source, the file may have moved, or your account may lack access. Check the source location and permissions, then use Data > Workbook Links to inspect or change the source when that control is available.

Does #REF! always mean an external workbook is missing?
No. #REF! can indicate that a formula refers to a deleted row, column, cell, or worksheet, or that an external reference is invalid. Inspect the formula and its source before deciding which repair is needed.

Will changing a workbook link update every formula?
It can update references associated with the selected source, but not every kind of connection or broken reference in the workbook. Check other sources, defined names, and data connections, then verify important results.

What happens if I break a link?
Breaking an external workbook link generally replaces linked formulas with their current values, so those cells no longer update from the source. Treat this as a potentially irreversible change, save a separate copy first, and confirm that a static snapshot is what you need.

Why does a link work for me but not for a coworker?
The coworker may not have access to the destination, may be signed in with a different account, or may not have the same network or folder path. Use a shared location with suitable permissions and test the link from the recipient’s access context.

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.