Excel Broken Link: How to Find and Fix It

Errors & fixes · Updated November 19, 2026

To fix a broken link in Excel, first identify whether it is an external workbook link, a broken formula reference, or a clickable hyperlink. For an external link, restore or locate the source workbook, then use Data > Workbook Links and choose Change source; if the problem is a clickable hyperlink, right-click it, choose Edit Hyperlink, and correct its address.

What a broken Excel link means

People use “broken link” to describe several different problems. An external workbook link is a formula or other workbook element that gets information from a separate Excel file. It may stop updating because the source file was moved, renamed, deleted, or is no longer accessible. A broken formula reference is different: Excel displays an error such as #REF! because a cell or range that the formula depended on was deleted or otherwise became invalid. A hyperlink is simply a clickable address to a file, web page, or location; it can fail even when the workbook contains no external formulas.

Work out which kind of link you have before changing anything. A message asking whether to update links when opening a workbook usually concerns external workbook data. A cell displaying #REF! points to a formula reference problem. A cell that looks normal but opens the wrong page or reports that a file cannot be found is more likely to contain a hyperlink. These issues need different fixes, and breaking an external link will not repair a hyperlink or restore a deleted formula reference.

Find where the link is coming from

In Excel for Microsoft 365 on Windows, open the workbook and check the Data tab for Workbook Links. Selecting a listed source lets you inspect or manage the connection; the available controls can include changing the source, refreshing values, or breaking the link. In some older Excel versions the corresponding command is called Edit Links. The location and wording can vary by version, so use the command shown in your build rather than assuming every workbook has the same dialog.

If the source is not obvious, search the workbook for references to another file. Press Ctrl+F, open the search options, set Within to Workbook and Look in to Formulas, then search for an opening square bracket, [. External workbook formulas commonly include a workbook filename in square brackets. Review each result rather than changing every match automatically: text in a formula, a note, or a legitimate reference may not be the broken link you are trying to fix.

Also inspect Formulas > Name Manager. Defined names can point to ranges in another workbook even when the visible cell formulas do not make the source easy to spot. Charts, pivot tables, data validation, conditional formatting, and embedded objects can also retain references to external files. A search is a useful first pass, not proof that every external dependency has been found.

Repair a link after a workbook was moved or renamed

If the source file still exists, the cleanest repair is usually to point Excel to its current location. Make sure you know which source workbook is intended; two files with similar names may contain different data. It is safer to confirm the source file and, if practical, open it before updating the dependent workbook.

  1. Save a copy of the workbook you are repairing, especially if it contains important formulas or reports.
  2. Open the dependent workbook and select Data > Workbook Links. If your version uses the older command, select Data > Edit Links.
  3. Select the link to the moved or renamed source and choose Change source, or the equivalent command available in that window.
  4. Browse to the correct workbook, select it, and confirm the change.
  5. Refresh the link if needed, then check key cells, charts, and reports against the source data before relying on the results.

For example, a monthly report may have been linked to a file in a former team folder. If the current file is the same source workbook in a new folder, changing the source path can restore the connection without rebuilding the report. If the replacement file has different sheet names or a different layout, however, pointing Excel to it may not be enough: formulas can still refer to sheet names or cell ranges that do not exist in the new file.

Excel may ask whether to update links when you open a workbook. Update only when you recognize and trust the source and expect its current values to be used. If you are unsure, decline for the moment, inspect the source path in Workbook Links, and verify the file before refreshing. A prompt by itself does not establish that the linked file is safe or that its contents are correct.

What to do when the source file is missing

If the source workbook was deleted or is unavailable, first check likely locations: the original folder, a shared drive, a cloud storage account, a colleague’s copy, or your organization’s backup and version history. Search by the filename shown in the link details. If the workbook was renamed, searching for a distinctive part of its old name can help locate it. Restore the original file or obtain the correct replacement before changing the link whenever possible.

If the source cannot be recovered, decide whether the dependent workbook needs live updates or only its last available figures. A saved copy may retain displayed values from the last successful update, but those values can be stale and are not a substitute for the missing source. Check dates and compare important totals with a reliable record. If the report needs current data, rebuild or reconnect it to an authoritative source rather than treating old values as current.

Do not create a blank workbook with the missing filename just to make the warning disappear. Excel might find a file with that name, but it will not contain the original data or structure, and dependent formulas may return errors or misleading results. A replacement should be verified for the relevant sheet names, fields, and values.

Fix a #REF! error in a formula

#REF! means a formula contains an invalid reference, often because a referenced row, column, cell, or worksheet was deleted. Restoring a moved external file will not necessarily fix this error. Select the affected cell and read the formula in the formula bar to see where the invalid reference appears. If the deleted range was removed recently, Undo may restore it, provided you have not closed the workbook or made later changes you need to keep.

If the deletion cannot be undone, edit the formula to refer to the correct existing cells or rebuild the calculation from its intended inputs. Do not replace every #REF! with zero or a blank just to hide the error: that can make totals and decisions wrong. For a formula copied across many cells, inspect representative cells and confirm that each reference should shift or remain fixed as it is copied. If the formula was created by another person, ask what the deleted range was meant to represent before guessing.

Repair a clickable hyperlink

A hyperlink can be broken independently of workbook links. Right-click the cell or object containing it and choose Edit Hyperlink. Check the Address field for the correct web address or file path, edit it, and confirm. For a link to a location inside the workbook, check that the destination sheet or named location still exists. If a worksheet was renamed, the old destination may no longer work even though the workbook itself opens normally.

For a file hyperlink, confirm that the target file exists and that the people who need to use the workbook can access its location. A path on your computer may work for you but fail for colleagues whose computers do not have the same folder. A shared location with appropriate permissions is generally more suitable for a workbook used by a team. For a web link, check that the address is current and that the destination does not require an account the recipient lacks.

Should you break the external link?

Breaking a link is not the same as repairing it. It removes the connection to the source and generally replaces linked formula results with their current values. Those cells will no longer update from that workbook, and the original linked formulas cannot be recovered simply by refreshing. Make a separate copy first if you may need the formulas or future updates.

Breaking links can make sense when a report is being archived as a fixed snapshot, the source is permanently unavailable, and retaining the displayed values is intentional. It is usually a poor choice for a model, forecast, or recurring report that must update. Before using a Break link command, check which source is selected and whether other sheets or charts depend on it. If you need a permanent record, label the snapshot with its date and source rather than leaving future users to assume it is live.

Other causes and ways to prevent repeat problems

Not every external reference is managed in the same place. Power Query imports and other data connections are not necessarily ordinary cell-to-cell workbook links. If a refresh fails, open Data > Queries & Connections and inspect the relevant query or connection, then use Data > Refresh All only when you intend to refresh the workbook’s connected data. A query may need its own source path or sign-in details corrected; changing a Workbook Links source will not automatically repair every data connection.

To make links less fragile, keep shared source files in stable, permission-controlled locations and avoid renaming or moving them without telling workbook owners. Document which files a recurring report depends on. Before distributing a workbook, check Workbook Links and queries, test important hyperlinks, and confirm whether recipients should receive a live report or a static snapshot. If a team changes folder structures, plan and test the move with a copy before updating production workbooks.

Excel for the web and Excel for Mac may show different controls from Microsoft 365 for Windows, and some link-management options depend on the version. On Mac, look on the Data tab for Workbook Links or Edit Links where available; if a command is absent, use a current desktop version that exposes the relevant link controls. The common search shortcuts differ: use Ctrl+F on Windows and Command+F on Mac. Menu labels and available actions can change between releases, so check the version-specific interface when a named command is missing.

Frequently Asked Questions

Why does Excel say it cannot update links?

Excel cannot reach or read one or more linked sources. The source may have moved, been renamed, been deleted, or require permissions or credentials. Inspect the source listed under Workbook Links, confirm that the file is available, and refresh only after verifying that it is the intended workbook.

How do I find all external links in an Excel workbook?

Start with Data > Workbook Links, then search formulas across the workbook for an opening square bracket and check Formulas > Name Manager. Also review queries, connections, charts, and other objects if you suspect hidden dependencies. No single search method is guaranteed to locate every kind of external reference.

Will breaking a link delete my data?

Breaking an external workbook link generally removes the connection and leaves the current displayed results as values, so those cells stop updating. It can discard the linked formulas, which is why you should save a copy first and confirm that a fixed snapshot is what you want.

Why is #REF! still showing after I changed the source?

#REF! usually means the formula itself refers to a deleted or invalid cell, range, or sheet. Changing an external file path cannot restore a reference that no longer exists. Edit the formula to use the correct valid location, or recover the deleted content if possible.

How do I fix a broken hyperlink in Excel?

Right-click the linked cell or object, choose Edit Hyperlink, and correct the Address field. Check that the target exists and is accessible to the people who will use the workbook; a local file path may not work for other users.

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.