Excel Workbook Links Not Working? Fix the Common Causes

If Excel workbook links are not working, first check whether you mean a formula that pulls data from another workbook or a clickable hyperlink: they fail for different reasons. For an external workbook formula, open the source file and use Data > Workbook Links to check or change its location; for a clickable link, edit the hyperlink and verify its destination.

Identify which kind of link is failing

An external workbook link is a formula reference to a cell in a different workbook. In a formula, it commonly includes the source workbook’s name in square brackets, followed by a worksheet name and cell reference. Excel may ask whether to update these links when you open the file. If the source workbook cannot be found or accessed, the destination workbook may show an old saved value or an update error.

A hyperlink is different: it is an address you click to open a web page, file, email address, or location in a workbook. A hyperlink can look like ordinary text or be attached to a shape or image. Clicking it does not refresh data. That distinction matters: changing a workbook’s source path will not repair a broken hyperlink, and editing a hyperlink will not update a formula linked to another workbook.

There are also workbook connections, such as Power Query connections, that import or refresh data. They are not the same as cell-to-cell workbook links. If the issue involves a query or imported table, check the connection and refresh settings instead of treating it as a broken formula link.

Check whether the source workbook moved

The most common cause of a broken external link is that the source workbook was renamed, moved, deleted, or placed somewhere the current user cannot access. For example, a link that points to a file in a former employee’s local Documents folder will not work for colleagues whose computers do not have that same path. A file moved from a network drive to SharePoint can cause the same problem.

First, locate the source workbook and confirm that you can open it. Check the exact file name, folder, and access permissions. If it is stored on a shared drive or SharePoint, confirm that the drive or account is available and that you are signed in with an account allowed to open it. A source file that exists but requires permission is not necessarily a missing file.

In Excel for Microsoft 365 on Windows, select Data > Workbook Links to inspect available workbook links. In some earlier Excel versions, the equivalent command is Data > Edit Links. The pane or dialog shows source workbooks and offers actions such as updating or changing a source, although the controls can differ by version. If the source is available, open it before refreshing the destination workbook.

Update a link or point it to a new source

When Excel asks whether to update links, choose to update only if you recognize and trust the source and want the destination workbook to use its latest values. If you choose not to update, Excel may retain the values saved in the destination file the last time it was refreshed. Those saved values can look plausible while being out of date, so check the last update date or compare a known value with the source.

If the source workbook has moved, use the link-management controls to change the source to the correct file, then update the link. In older versions, the Edit Links dialog includes a Change Source action. In current Microsoft 365 builds, use the options shown in the Workbook Links pane. Select the correct workbook, not merely a similarly named file, and verify that the linked values now match the intended source.

If the source workbook is temporarily unavailable, do not redirect the link to a different file just to remove the warning. That can replace correct references with unrelated data. Restore access to the original source or ask its owner for the correct current location. If you do not need live links, make a separate copy of the destination workbook before considering a conversion to fixed values.

Repair a clickable hyperlink

For a hyperlink in a cell, right-click the cell and choose Edit Hyperlink to inspect its address. Correct a misspelled web address or file path, or select the intended destination again. You can also select the cell and press Ctrl+K on Windows to open the link dialog. On Mac, use Command+K. The labels and dialog layout can vary slightly between desktop versions.

For a link to a local file, check that the file still exists at the address recorded in the hyperlink. Links that use a relative path can depend on where the workbook itself is stored; moving only the workbook or only the target file may break the relationship. A link to a network location can also fail when the computer is disconnected from that network or the user lacks permission. For a web link, check that the address includes the correct domain and that the page has not been removed or moved.

Shapes and images can have hyperlinks too. Select the object, right-click it, and inspect its link options rather than editing a nearby cell. If a link opens the wrong place, check whether it points to a specific sheet or cell in the current workbook. A hyperlink to an internal location can stop being useful after that sheet or target cell is renamed, deleted, or reorganized.

Find links that are not obvious

A workbook may contain external references even when the visible cells do not appear to have links. Links can be embedded in formulas, defined names, chart series, or other workbook features. Searching the worksheet for the source file name can help, but a normal search may miss references outside visible cell formulas.

Use Find to search for the source workbook’s name, including its file extension, and set the search scope to the workbook if that option is available. Search formulas as well as displayed values.
Open Formulas > Name Manager and inspect names whose Refers to entries point to another workbook or an obsolete file path.
Check charts if their series may refer to ranges in a different workbook. Select a chart and inspect its data source or series references.
Look separately at queries and connections if the data came from an import. Use Data > Refresh All only when you intend to refresh those connections and have access to their sources.

Finding a reference is not the same as deciding to remove it. A name or chart may be used in a report even if its source is not obvious. Before deleting or changing anything, make a copy and confirm what depends on the reference.

Understand update warnings and security settings

Excel may block or ask about external content because links can bring information into a workbook from outside the file. A warning is not proof that the workbook is malicious, but it is a reason to verify who supplied the file and whether you trust the source. Do not enable content or weaken security settings simply to make an unfamiliar workbook appear to work.

If you trust the file and the source, follow the prompt or use the workbook-link controls to update it. If Excel reports that the source cannot be updated, investigate the path, permissions, and sign-in status rather than turning off protections globally. In a managed workplace, an administrator may set policies that control external content; ask the organization’s support team before changing settings.

Excel for the web can open and display many workbooks, but some link-management or repair tasks may require the desktop app. If the web version does not expose the control you need, open the workbook in desktop Excel and use the available Workbook Links tools. Interface options can differ between Windows, Mac, and web editions, so use the equivalent link controls shown in your version rather than assuming every menu is identical.

Check calculation and saved values

Sometimes the link exists, but a displayed result does not change. One possible cause is manual calculation. In desktop Excel, check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook. Then recalculate and compare the result with the source. Automatic calculation can affect formulas generally, not just external links, so consider the workbook’s intended performance and behavior before changing it.

Another possibility is that Excel has a saved or cached value from an earlier update. A number visible in a cell does not by itself prove that the source is currently connected. Confirm the link status in the Workbook Links pane and check a value that has recently changed in the source. If the link is current but the displayed result remains unexpected, inspect the formula and the source cell; the issue may be a calculation or data problem rather than a broken path.

Use a safe troubleshooting order

A careful sequence helps avoid replacing good data or losing formulas while diagnosing the problem:

Save a copy of the destination workbook before making repairs, especially before changing or breaking links.
Decide whether the failing item is an external formula link, a clickable hyperlink, or a data connection.
Check that the source file or destination address exists and that your account can access it.
Use the relevant link controls to inspect the source, correct its location if necessary, and update it only when the source is trusted.
Verify a known result or destination, then save and reopen the workbook to confirm that the repair persists.

Breaking a workbook link is a last resort, not a general repair. In desktop Excel, breaking links typically replaces linked formulas with their current values, so those cells no longer update from the source. Treat the action as difficult to reverse and work from a copy; do not use it when the workbook needs to remain connected to live data.

Prevent links from failing again

Keep related workbooks in a stable shared location, and avoid moving or renaming source files without updating the workbooks that depend on them. If several people use the same files, use a location they can all access rather than a personal desktop folder. Agree on file names and folder structure, and tell workbook owners before changing either.

Document which workbook supplies important linked figures and who maintains it. For recurring reports, include a clear refresh date or status note so readers can distinguish current data from saved values. If a report only needs a snapshot, consider distributing a separate values-only copy while preserving the linked working file for future updates. That makes the purpose of each version clear and reduces accidental changes to the live source relationship.

Frequently Asked Questions

Why does Excel say it cannot update links?

Excel usually cannot reach the source workbook or does not have permission to read it. Check whether the file was moved or renamed, whether a shared drive is connected, and whether you are signed in with the right account.

Why does my workbook show old linked values?

The workbook may be displaying values saved during an earlier update, or calculation may be set to Manual. Check the link status, update from a trusted source, and review Formulas > Calculation Options.

How do I find external links in an Excel workbook?

Start with Data > Workbook Links, or Data > Edit Links in older versions. Also search formulas for the source file name and inspect Name Manager and chart references, because not every link is in an obvious cell.

Will breaking a link delete the source workbook?

No. Breaking a link changes references in the destination workbook; it does not delete the separate source file. It can replace linked formulas with fixed values, so keep a copy before doing it.

Why does my Excel hyperlink not open?

Its web address or file path may be incorrect, or the destination may have moved or become inaccessible. Edit the hyperlink, verify the address, and check that you can open the destination directly.

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.