How to Break Links in Excel: Every Method Explained (2026)

Method 1: The Edit Links (Workbook Links) Dialog Box

This is the primary solution, and it covers the majority of cases.

1. Open the workbook containing the links.
2. Click the Data tab.
3. Click Edit Links or Workbook Links in the Connections group.
4. The dialog box lists every source file, its type, its update status, and its full path.
5. Highlight one entry, or several for multiple links.
6. Click Break Link, then confirm.

In current Microsoft 365 builds, Workbook Links opens a task pane on the right of the page rather than a dialog box. Each source appears with a small arrow or three-dot menu beside it containing Break links, plus a Break all links command at the top that clears every external reference in one action. To target specific links only, use the per-source menu instead.

Method 2: Copy and Paste as Values

A precise method for when only a few cells reference external workbooks, or when Break Link is unavailable.

1. Select the cells containing external formulas.
2. Press Ctrl + C to copy.
3. Right-click the selection and open Paste Special from the paste options, or press Ctrl + Alt + V.
4. Choose Values, then OK. Keyboard only: Ctrl + Alt + V, then V, then Enter.

The formulas become current values, and the link is broken for those cells while the rest of the workbook stays intact. The same technique appears in most guides to replacing a formula with its result, and it pairs well with cleaning up cell borders and column formatting once the values are locked.

Method 3: Find All to Locate Links First

Decide what to break only after you locate every reference. External links contain square brackets around the source file name, which makes them searchable.

1. Press Ctrl + F.
2. Click Options, set Within to Workbook and Look in to Formulas.
3. Search for [ or for .xl.
4. Click Find All.

The results box becomes a clickable index of every cell holding linked data, with sheet, cell, and formula shown in each column. Clicking a row jumps straight to that cell.

Method 4: Change Source Instead of Breaking

Sometimes a working link beats no link. In the Edit Links dialog box, Change Source opens a file browser. Point it at the current location of the source workbook and every formula referencing the old path updates at once. This is the correct fix when a drive letter changed, or the source file moved to a new folder.

Tip: If the data only needs to arrive once, copy the source range into a new workbook and paste as values, then work from that clean file.

Method 5: VBA Macros for Bulk Removal

For a workbook with dozens of sources, or a routine that runs on a set date each month, macros clear everything in one pass. Press Alt + F11, insert a module, and paste:

Sub BreakAllLinks()
    Dim links As Variant
    Dim i As Integer
    links = ActiveWorkbook.LinkSources(xlExcelLinks)
    If Not IsEmpty(links) Then
        For i = 1 To UBound(links)
            ActiveWorkbook.BreakLink Name:=links(i), Type:=xlLinkTypeExcelLinks
        Next i
    End If
End Sub

Press F5 to run it. The macro loops through every Excel link and converts each to values. Save the file as .XLSM if the macro needs to persist.

Common Issues and Troubleshooting

Unable to click Break Link. The button is greyed out most often because of protection. Open the Review tab and select Unprotect Sheet, then repeat for every sheet. Files opened in Protected View show the same symptom.

Links keep reappearing. Break Link only handles cell formulas. Several objects hold references that the dialog box ignores:

• Defined names: Open the Formulas tab, then Name Manager, and read the Refers To column for square brackets. Delete or edit any named ranges pointing outside the workbook. Stale defined names are the single most common cause of a link that refuses to break.
• Chart series: Select the chart, click Select Data, and check each series formula for an external path.
• Conditional formatting: Under Home, open Manage Rules, set the scope to each worksheet in turn, and inspect the rule formulas.
• Data validation: Select the cells, open Data Validation, and check the Source box.
• Shapes, buttons, and images: Click each of these shapes and read the formula bar.
• Hidden sheets: Right-click a sheet tab, choose Unhide, and repeat the audit there.

PivotTables still show a source - A PivotTable built on external workbooks holds its own connection. Use PivotTable Analyze, then Change Data Source, to repoint it locally, or convert it to static values.

Queries persist - Power Query connections appear under Data, then Queries & Connections. Right-click each query and choose Delete.

The prompt appears with no visible links. In stubborn cases, the reference lives in the XML file. Save a backup, change the extension from .XLSX to .ZIP, delete the externalLinks folder inside xl along with the matching entries in xl/_rels/workbook.xml.rels, then rename it back. Treat this as a last resort.

Excel for the web. The browser version is unable to break links. Open the file in the desktop version instead.

Excel for Mac: The command sits under Data, then Edit Links. Older versions place it on the Edit menu.

Note on the security warning: To keep links intact but stop the alert, open Edit Links, click Startup Prompt, and choose Don't display the alert and don't update automatic links. The setting saves with the workbook.

Breaking Links Programmatically with IronXL

Teams dealing with spreadsheets in bulk, on a server, or inside a scheduled process need this to happen without opening Excel at all. IronXL is a .NET library that reads and writes Excel files directly, with no Office installation and no Interop dependency, which suits web applications and background services.

Converting formulas to their current values breaks external references across an entire workbook:

using IronXL;

WorkBook workbook = WorkBook.Load("QuarterlyReport.xlsx");

foreach (WorkSheet sheet in workbook.WorkSheets)
{
    foreach (var cell in sheet.Rows.SelectMany(row => row))
    {
        if (!string.IsNullOrEmpty(cell.Formula))
        {
            cell.Value = cell.Value;
            cell.Formula = null;
        }
    }
}

workbook.SaveAs("QuarterlyReport_Static.xlsx");

using IronXL;

WorkBook workbook = WorkBook.Load("QuarterlyReport.xlsx");

foreach (WorkSheet sheet in workbook.WorkSheets)
{
    foreach (var cell in sheet.Rows.SelectMany(row => row))
    {
        if (!string.IsNullOrEmpty(cell.Formula))
        {
            cell.Value = cell.Value;
            cell.Formula = null;
        }
    }
}

workbook.SaveAs("QuarterlyReport_Static.xlsx");

Imports IronXL

Dim workbook As WorkBook = WorkBook.Load("QuarterlyReport.xlsx")

For Each sheet As WorkSheet In workbook.WorkSheets
    For Each cell In sheet.Rows.SelectMany(Function(row) row)
        If Not String.IsNullOrEmpty(cell.Formula) Then
            cell.Value = cell.Value
            cell.Formula = Nothing
        End If
    Next
Next

workbook.SaveAs("QuarterlyReport_Static.xlsx")

The result is a clean new workbook with static values and no lingering source paths, produced in a few lines rather than a manual pass through every sheet.

Summary

This article covered every reliable route, from ribbon commands to macros. Most files need nothing more than Edit Links on the Data tab. Paste Special handles targeted cells, Find All helps you locate references before you decide what to break, and macros cover workbooks with many sources. When links survive every attempt, the cause is almost always the Name Manager, a chart series, a conditional formatting rule, or a Power Query connection rather than a cell formula. For teams automating this work across hundreds of files, IronXL strips external references in code, and its tutorials on reading and writing Excel files cover the wider set of operations that usually accompany a cleanup job. You can also download a free trial to explore its features in your own projects.