Broken Links in Excel: How to Find and Fix Them

A finance manager at my company once forwarded me a workbook at 4:47 PM on a Friday with one line in the email: "It's broken, presentation is Monday." The file had seventeen external links. Twelve were pointing to a folder path that no longer existed, because someone had reorganized the shared drive three weeks earlier and renamed half the directories. The original file had probably been called something like Budget_Final_v3_REVISED_ACTUALLY_FINAL.xlsx at some point. Nobody left a note.

Broken links in Excel are almost never a mystery once you know where to look. The problem is that Excel hides them in more places than most guides cover, and if you've already tried the obvious fix and the update prompt keeps coming back, there's a good reason. Let's work through every hiding spot, in order, so you can close the file cleanly.

The Edit Links dialog is your first stop — but it won't catch everything.

What You'll Fix (and the One Thing to Check Before You Start)

The goal here is a workbook that opens without prompting you to update anything, with no lingering Excel cannot update one or more links warnings, and no formulas returning errors because a source file has moved. External links are workbook references that pull data from a separate file. They break the moment that source file is renamed, moved to a different folder, or deleted. That's it. One rename on a shared drive and everything downstream collapses.

Before you start: open the Data tab and check whether the Edit Links button is available. If it's grayed out, your workbook has no external links Excel can currently detect, which actually might mean the problem is hiding somewhere else (more on that in Step 2). If it's active, you're ready.

Why Excel shows the update links prompt in the first place

Every time you open a file with workbook references, Excel tries to refresh those connections from their source files. If the source file has moved, been renamed, or simply isn't accessible from your current machine, Excel can't complete that refresh and either prompts you to update or silently marks the link as broken. The prompt itself isn't the problem. A broken file path is.

If you're new to how Excel handles errors in general, the common Excel errors and troubleshooting guide has useful background on how Excel signals connection and formula failures.

Step 1: Use the Edit Links Dialog to Find Every Broken Link Source

Go to Data → Edit Links. You'll see a list of every external file this workbook is referencing. Each entry has a Status column, and that's the only column you need to care about right now.

How to read the status column and spot which sources are broken

A status of OK means Excel found the source file and refreshed successfully. A status of Error means it couldn't. For every Error entry, click it, then click Change Source. Navigate to wherever the source file actually lives now, whether it was moved, renamed, or saved to a new folder, select it, and click OK. The status should flip to OK.

The Edit Links dialog shows you the full source path and lets you remap it manually. In Microsoft 365 as of 2026, this dialog also includes a Check Status button to force a refresh if statuses look stale.

Once every source shows OK, click Close. Save the file. If the warning prompt is gone when you reopen it, you're done. If it's not — and this is where most guides stop being useful — keep going.

Step 2: Hunt Down Hidden Broken Links in Named Ranges, Data Validation, and Conditional Formatting

The Edit Links dialog only shows you links it can see. There are at least three places where broken external references hide that the dialog completely misses, and they're the reason the Break Link button sometimes does nothing, or why the update prompt survives even after you've fixed every listed source.

Checking named ranges in Name Manager

Go to Formulas → Name Manager. Scan the Refers To column for any entry that contains a file path in square brackets, something like [OldReport.xlsx]Sheet1!$A$1. That's a named range pointing to an external file. If that file no longer exists, delete the named range or update the reference. This is one of the most common culprits in inherited workbooks: the original linked file is long gone, and the ghost reference lives on in Name Manager untouched.

Data validation rules are the other major hiding spot. Select all cells with Ctrl+A, then go to Data → Data Validation → Data Validation. In the dialog, look for any Source field containing an external file path. You can't fix this in bulk. Use Find & Select → Data Validation under the Home tab to locate the affected cells, then update or remove the external source from each one.

Conditional formatting is the third. Go to Home → Conditional Formatting → Manage Rules, set "Show formatting rules for" to This Worksheet, and look for any rule with an external reference in its formula. These usually sneak in when someone copies a range from another workbook without thinking about it.

Why Break Link stays grayed out and what to do instead

If the Break Link button in the Edit Links dialog is grayed out, it almost always means one of two things: the workbook is protected, or the links are embedded somewhere the dialog can't reach (data validation, conditional formatting, or a shape object). Unprotect the sheet first if protection is on. If Break Link is still unavailable, the fix is manual: remove the hidden references in Name Manager, validation rules, and formatting rules yourself, then return to Edit Links.

Don't assume clicking Break Link cleared everything. If data validation or conditional formatting rules still contain external references, the update prompt will return the next time you open the file.

Broken external references hiding in these spots behave differently from formula-based errors like a #REF! error in Excel, but the diagnostic instinct is the same: look past the obvious and check the structure.

Step 3: Run a Quick VBA Macro to Catch Any Broken Links Still Hiding

If you've been through Steps 1 and 2 and the workbook is still complaining, a short VBA macro will sweep the file and report exactly what's still broken. Copy this into the VBA editor (Alt+F11 → Insert → Module) and run it:

Sub FindBrokenLinks()
    Dim lnk As Variant
    Dim msg As String
    msg = ""
    For Each lnk In ThisWorkbook.LinkSources(xlExcelLinks)
        If ThisWorkbook.LinkInfo(lnk, xlLinkInfoStatus) = xlLinkStatusMissingFile Then
            msg = msg & lnk & vbNewLine
        End If
    Next lnk
    If msg = "" Then
        MsgBox "No broken external links found."
    Else
        MsgBox "Broken links:" & vbNewLine & msg
    End If
End Sub

It loops through all external workbook references and flags anything with a missing file status. Fast, clean, no guessing. If you're not comfortable writing or modifying VBA, Microsoft Copilot in Microsoft 365 can generate or adapt this macro from a plain-English description.

Common Mistakes When Fixing Broken Links in Excel

The most common mistake is assuming that clicking Break Link in the Edit Links dialog cleared everything. It didn't — not if data validation or conditional formatting rules still contain external references. Skipping Name Manager is the second one. It takes thirty seconds to check and catches a surprising number of ghost references, especially in inherited files or anything that's passed through multiple hands.

For teams sharing workbooks: keep all linked files in a shared folder with a stable path, and agree on a naming convention that doesn't involve version suffixes. The moment someone saves a copy as Report_Q2_FINAL2.xlsx in a different directory, every workbook referencing the original breaks silently, and nobody finds out until the next deadline.

Keep all linked source files in one shared folder with a stable path. A single rename or move can silently break every workbook that depends on it.

If you're running into formula errors alongside link issues, the Excel for beginners guide covers how Excel handles cell references and external connections at a foundational level, which helps when a formula keeps failing even after the link is repaired.

Frequently Asked Questions