Fix a Broken Workbook Link in Excel

To fix a broken workbook link in Excel for Microsoft 365 on Windows, open the workbook that contains the link, go to Data > Workbook Links, select the affected source, and choose Change source to point Excel to the correct file. If the link is already showing #REF!, repair the formula or restore the missing sheet or cell reference; changing the source file alone may not fix it. Before you begin, make a copy of the workbook and locate the intended source file.

What You’ll Need

A copy of the workbook with the broken link. Use File > Save As to make a separate working copy if the file is important.
The correct source workbook, if the link is meant to connect to another Excel file. Know its current folder and filename, and check that you can open it.
Permission to access the source location. For a network drive or cloud folder, sign in or connect to the required network before updating the link.

Step-by-Step

Open the workbook and check the warning. Open the workbook containing the broken link. If Excel displays a message that the workbook contains links to external sources, do not automatically enable or refresh links you do not recognize. Choose the option to continue opening the workbook, then verify the source before updating it. A broken link may display an error, show an old value, or prompt for a file when you open the workbook.
Confirm the intended source file. Find the workbook the formulas are supposed to use. Check its filename, folder, and whether it opens normally. If it has been renamed or moved, locate the current version rather than creating a replacement file with a similar name. When possible, compare it with a known-good copy or ask the workbook owner which file is authoritative. A link to the wrong but similarly named workbook can return plausible-looking, incorrect figures.
Open the workbook-link controls. In Excel for Microsoft 365 on Windows, select the Data tab and choose Workbook Links. Depending on your update channel or Excel build, the older command may appear as Data > Queries & Connections > Edit Links. If neither command appears, see Troubleshooting below; the link may be embedded in a formula or another workbook feature rather than listed in the link manager.
Identify the broken source. In the Workbook Links pane or Edit Links dialog, look for the source whose status indicates an error, or whose path or filename no longer matches the file you found. Select a source and review its details before changing it. If the workbook has several external sources, handle them one at a time and make sure each source has the correct purpose. Do not change every source to the same file just to clear a warning.
Change the source to the correct file. Select the affected link and choose Change source (the older dialog may use Change Source). Browse to the correct workbook, select it, and confirm. Excel will redirect references associated with that linked source to the chosen workbook. This is usually the right fix when the source workbook was moved or renamed but its worksheet names and referenced cells are still available.
Refresh the linked values. With the source workbook available, use the refresh or update command shown for the link, if Excel offers one. If a security prompt asks whether to update links, proceed only after confirming that the source is trusted and is the one you intended to use. Check that the values recalculate and that the status no longer reports a problem. If Excel asks you to locate a file again, check the selected path and access permissions.
Inspect results in the destination workbook. Review several cells that use the link, including a total or other important result, and compare them with the source workbook. Look for #REF!, #VALUE!, unexpected blanks, or figures that appear out of date. Changing a source can make a link technically valid while still pointing to the wrong worksheet or data. Do not assume that a cleared warning means every result is correct.
Save, close, and reopen the working copy. Save the workbook, close it, and reopen it to confirm that the link remains fixed. If Excel displays an update prompt again, note the source named in the prompt and investigate why it is not resolving. Keep the original backup until you have checked the workbook and confirmed that other users can access the source too.
Repair individual references if needed. If the source appears correct but particular cells still show #REF!, select one affected cell and inspect its formula in the formula bar. A reference may point to a worksheet that was deleted or renamed, or to a cell range that no longer exists. Restore the missing sheet or correct the reference to the intended sheet and cell. If many formulas are affected, identify the pattern first and repair a small sample before applying a broader change.
Check for links outside ordinary cell formulas. If the link manager does not show the problem, search for external references and inspect workbook features such as defined names and charts. Press Ctrl+F, choose Options, set Within to Workbook and Look in to Formulas, then search for an opening square bracket ([). External workbook formulas commonly include the source filename in brackets. Review each result before editing; a search-and-replace across the whole workbook can change unrelated text or references. Also check Formulas > Name Manager for names whose Refers to value contains an obsolete path or #REF!.

On Mac, the names and placement of link-management commands can differ by Excel version. Check the Data tab for a workbook-links or edit-links command. If it is not available, use Find and Name Manager to locate formula and defined-name references, and consult the commands available in your installed version. Excel for the web may let you view or refresh some workbook links, but desktop Excel provides more complete tools for managing and repairing them.

Common Mistakes

Choosing a file just because its name matches. Two files can share a name but contain different periods, worksheets, or data. Check the folder and contents before redirecting the link.
Assuming Change source repairs every error. It can redirect an external workbook link, but it cannot recreate a deleted worksheet, restore a removed cell, or repair a broken reference typed into a formula.
Clicking Break Link to remove the warning. Breaking a link generally replaces linked formulas with their current values. Those cells no longer update from the source, and the change may be difficult to reverse. Use it only when you deliberately want a static snapshot and have saved a backup.
Using Find and Replace without checking the scope. A broad replacement can alter valid formulas, text, or other workbook paths. Find matches first, inspect the results, and change only references you understand.
Updating links from an untrusted workbook. External links can retrieve data from another file. Do not refresh a source simply because Excel asks; verify who provided it and whether it is expected.

Tips

Keep linked files in a stable location. A shared folder that users can access is generally more reliable than a personal Downloads folder or a temporary drive letter.
Coordinate folder changes. If a team reorganizes shared files, update the source path and tell workbook users where the source now lives. Otherwise, the link may work on one computer but fail on another.
Check worksheet names as well as filenames. A source workbook can be found successfully while individual references fail because a sheet was renamed or removed.
Keep a recovery copy until results are verified. A backup makes it possible to compare original formulas and values if an update changes results unexpectedly.
Record what you changed. For a shared or business-critical workbook, note the old source path, the replacement path, and the date. This makes later maintenance easier.

Troubleshooting

Workbook Links or Edit Links is missing. Confirm that you opened the workbook in the Excel desktop app rather than a preview or a limited web view. Check the Data tab for either the newer Workbook Links command or the older Edit Links command. If neither appears, the workbook may not contain a link type that the manager lists, or your version may place the command differently. Search formulas as described in step 10 and inspect Name Manager. Links can also exist in charts, objects, queries, or other workbook content, so a blank search is not proof that the entire file has no external connections.

Excel cannot find the replacement file. Browse to the file in File Explorer rather than typing a remembered path. Confirm the filename and extension, and make sure the file is not still in a compressed folder. If it is on a network share, connect to the network or VPN and confirm you have permission. Cloud files may need to be available locally or opened while signed in to the correct account.

The link updates but cells still show #REF!. Inspect the affected formula. If the referenced sheet no longer exists, restore it from a backup or revise the formula to use the correct existing sheet. If only some formulas fail, compare one working reference with one failing reference; differences in sheet names, ranges, or deleted rows can reveal the cause. Be careful when restoring deleted content because other formulas may depend on the same structure.

Values remain old after refreshing. Confirm that you selected the intended source and that its data is current. Check whether the source workbook itself contains old values or formulas that have not recalculated. Reopen the source if possible, verify its results, save it, and then refresh the destination. A saved linked value may not reflect changes that were never saved in the source.

The link works for you but not another person. The other person may not have access to your local folder, mapped drive, or cloud account. Move the source to a shared location that both users can access, then change the link to that shared copy. Ask the other user to open the workbook and confirm access; do not assume that a path resolving on your computer will resolve on theirs.

A warning returns every time the workbook opens. Check the exact source named in the warning, then confirm that the path is reachable and the file is available. If the link is obsolete and no longer needed, decide whether to remove or break it only after checking what depends on it and saving a copy. Avoid changing Excel’s security settings just to suppress a prompt; the prompt may be warning you about a source you have not verified.

Frequently Asked Questions

Why does Excel say it cannot update links?
Excel may be unable to locate the source file, lack permission to open it, or be unable to resolve a referenced sheet or cell. Confirm the file path and access first, then inspect any formulas that still show errors.

Will Change source fix a #REF! error?
Not necessarily. It can redirect a workbook link to a replacement file, but #REF! usually means a formula reference itself is invalid, such as a deleted sheet or cell. Check the formula and restore or correct the missing reference.

Can I repair a link if I do not have the original source workbook?
You can redirect the link only if you have a suitable replacement source. Without the original or an equivalent file, you may need to recover it from a backup or shared folder. Breaking the link keeps current values in many cases, but removes the live connection and should be a deliberate choice.

What happens when I break a workbook link?
Excel generally replaces formulas connected to that source with their current calculated values. Those cells stop updating from the source, and you may lose the original formula connection. Save a separate copy first and verify that static values are acceptable.

Can I fix an external link in Excel for the web?
Some link viewing or refresh options may be available in Excel for the web, but the available controls depend on the workbook and service. For a thorough repair, open the file in desktop Excel for Microsoft 365 and use its Data link-management commands or inspect the formulas directly.

How can I tell whether a link is actually repaired?
Check that Excel no longer reports the source as unavailable, refresh the link if appropriate, and compare several resulting cells with the intended source. Save, close, and reopen the workbook to confirm the path still resolves. A warning disappearing by itself does not confirm that the workbook is using the right data.

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.