Break External Links in Excel: Safe Ways to Remove Them

How-to basics · Updated November 21, 2026

To break an external workbook link in Excel for Microsoft 365 on Windows, save a backup, then select Data > Workbook Links, choose the linked source, and select Break links if that command is available. Breaking a link replaces formulas that depend on the source workbook with their current calculated values, so the result no longer updates when the source changes.

What breaking an external link means

An external link is a reference from one Excel workbook to data in another workbook. For example, a sales summary might use a formula to retrieve a forecast value from a separate planning file. As long as the link remains, Excel can update the result from that source workbook when it is available, subject to the workbook’s link and calculation settings.

Breaking the link is not the same as deleting the cell or simply hiding the reference. Excel replaces the linked formula with its currently displayed or calculated result, typically a number or text value. The cell keeps that value, but it no longer recalculates from the old workbook. This can be useful before sharing a finished report, but it removes the live connection and is not readily reversible.

Suppose cell C5 in your current workbook refers to cell B4 on the Forecast sheet in Budget.xlsx. If the source cell currently contains 12,500, breaking the link leaves 12,500 in C5 rather than a formula pointing to Budget.xlsx. The exact result depends on the value Excel has available when you break the link; if the source cannot be reached or the formula has an error, inspect that situation before proceeding.

Find and break links in Microsoft 365 for Windows

Start by making a copy of the workbook. Then open the copy in the Excel desktop app, since link-management commands and availability can vary between desktop and web versions. In current Microsoft 365 builds, the link list is commonly available from Data > Workbook Links. Select a source to review its status and available actions, then use Break links only when you are sure you want to replace its linked formulas with values.

  1. Save a separate copy with a clear name, such as Report_before_link_breaking.xlsx.
  2. Open the copy and select Data > Workbook Links. If you do not see that command, look for Data > Edit Links; the label and placement can differ across Excel releases.
  3. Review the listed source workbooks. Confirm that each one is genuinely an external source you intend to disconnect.
  4. Select the source and choose the break command. If Excel asks you to confirm, read the warning: breaking links converts dependent formulas to values.
  5. Save the file under a new name, close it, and reopen it. Check important totals and reports after reopening.

Some Excel versions present a command to break one selected source; others may offer to break all listed sources. Do not assume that a command affects only the active cell. It can affect formulas throughout the workbook that use the selected source. If the older Edit Links dialog appears, select the relevant source there and use its break-link control, following Excel’s confirmation prompt.

There is no universal keyboard shortcut for breaking workbook links. On Mac, the desktop app may offer link controls under Data > Edit Links, but the available commands and names can differ by Excel version. If the command is missing, use the formula-replacement approach below or open the file in a supported desktop version of Excel. Excel for the web can be useful for viewing and editing workbook data, but it may not expose the same full link-management controls as desktop Excel.

Choose between breaking, updating, and keeping a link

Breaking a link is only one response to an external reference. If a workbook is still meant to stay connected to a source, updating or repairing the link is usually more appropriate. If you need a self-contained snapshot for distribution, breaking may be right. If you still need future updates, keep the link and make sure the source file remains available in a stable location.

  • Update the link when the source workbook is correct and you want current values. Open or locate the source, then use the workbook-link controls to refresh or update as offered.
  • Change the source when the workbook moved or was renamed. Use the link-management command to point to the correct file, then verify the returned values.
  • Break the link when the current results are final and formulas no longer need to update from that source.
  • Keep the link when the workbook is part of a recurring process and its dependent formulas must remain live.

For instance, a monthly management report may need a frozen copy of last month’s figures for an archive, while the working report should continue drawing from the latest source workbook. Save a separate archival copy and break links only in that copy. This preserves the live workflow while producing a file whose reported numbers will not silently change when a source is updated later.

What happens to formulas and values

Before breaking a link, inspect representative formulas so you understand what will be replaced. With the formula entered in cell C5 of the current workbook, and the external file named Budget.xlsx containing a sheet called Forecast with the relevant value in B4, a typical reference is ='[Budget.xlsx]Forecast'!$B$4. If that source cell evaluates to 12,500, C5 returns 12,500. Breaking the link leaves the result as a constant value rather than preserving the formula.

This matters especially when a formula combines an external reference with other calculations. If C5 adds a local adjustment to the source value, breaking its external link can leave the formula’s current result rather than a formula that continues to recalculate the adjustment. In other words, do not expect Excel to rebuild a local formula that has the same logic but no external component. Review the values after the operation, particularly formulas that feed totals, charts, or other calculations.

Formatting generally remains with the cells, but a value is not a substitute for every feature associated with a formula or source. A workbook may also contain other external references that the link list does not make obvious. Breaking a listed source is therefore not proof that every external dependency in every feature has been removed.

Find hidden or overlooked external references

If Excel reports links but the main worksheet does not show an obvious formula, inspect other workbook features. A link can be embedded in a formula that is off-screen, on a hidden sheet, or in a defined name. Charts, conditional formatting rules, data validation settings, and objects can also refer to outside data, depending on how the workbook was built. These references may need separate review or editing.

  • Use Find to search formulas for an opening square bracket, which is common in external workbook references. Search the whole workbook and check formulas, not just displayed values.
  • Review hidden worksheets and unhide them temporarily if you are authorized to inspect their contents.
  • Open Formulas > Name Manager and inspect names whose references point to another file or an unavailable path.
  • Inspect chart series, conditional formatting rules, and data validation settings if a link remains unexplained.
  • Check whether the workbook uses queries, connections, or PivotTable sources. Those are data connections, not necessarily ordinary cell-formula links, and breaking a workbook link may not remove or refresh them.

Excel’s Find tool is a useful check, not a complete audit guarantee: a reference might be stored outside ordinary cell formulas, or the search might miss it because of the selected search options. In the Find dialog, set the search scope to the workbook and search in formulas where that option is available. After checking, use the link manager and inspect relevant workbook features rather than relying on one search result alone.

Manual alternatives and when not to use them

If the link manager is unavailable, you can replace formulas yourself, but do so carefully. Copy the relevant formula cells and use Home > Paste > Paste Special > Values to replace formulas with their current results. In Excel for Windows, Ctrl+C copies; on Mac, use Command+C. The Paste Special menu path is safer to describe than relying on a shortcut, because shortcuts can differ by platform and keyboard settings.

Manual conversion is best for a clearly selected range, not a workbook with many scattered references. Copying and pasting values over the wrong cells can erase formulas that have no external links. Work on a duplicate, verify the selection before pasting, and compare key outputs afterward. If the workbook contains many formulas or several linked sources, use the built-in link manager where possible so you can identify the source before taking action.

Do not confuse an external workbook link with a hyperlink. A hyperlink is a clickable address or file path, often inserted through Insert > Link; it does not necessarily feed a cell formula. Breaking a workbook link does not automatically mean every clickable hyperlink has been deleted. If you want to remove hyperlinks, select the relevant cells and use the hyperlink removal option separately, taking care not to remove links that readers still need.

Common problems and checks after breaking links

Excel still asks to update links. There may be another external reference, such as a defined name, chart, or a link in another sheet, or the prompt may relate to a data connection rather than the formulas you just changed. Reopen the workbook and inspect the link list and the other features described above.

The workbook has the wrong values after breaking. The value captured may have been stale, unavailable, or affected by calculation state. Before breaking, open the source workbook if possible, update or recalculate the dependent workbook, and confirm key figures. Do not break a link just to dismiss an update prompt if you have not verified the results.

The Break Links command is missing or unavailable. Check whether the workbook is open in desktop Excel and whether the selected item is a workbook link that Excel can break. A query, connection, hyperlink, or protected workbook situation may require a different action. Menu labels also vary by release, so check both Data > Workbook Links and the older Data > Edit Links location.

The workbook is much smaller after conversion. Removing formulas does not guarantee a smaller file, but the size can change depending on workbook contents and how much formula or cached data was present. File size alone is not evidence that the links were removed correctly. Reopen the file, review formulas and link status, and test critical outputs.

Frequently Asked Questions

Does breaking a link delete the source workbook?
No. It changes the dependent workbook; it does not delete the separate source file. The source remains where it was unless someone deletes it independently.

Can I undo a broken link?
Do not rely on Ctrl+Z to restore a broken link, especially after saving or closing. Keep a backup first. The dependable way to restore the original formulas is to reopen a pre-break copy or recreate the references from the source.

Will breaking links keep the current numbers?
Excel replaces dependent formulas with their current results, so it is intended to preserve the calculated values at the time of the operation. Check that the workbook has up-to-date values and no unresolved source errors before breaking links.

Why does Excel still show an external link after I broke one?
The workbook may contain more than one source or a reference in a defined name, chart, rule, query, or connection. Inspect the link manager and other workbook features; breaking one listed source does not necessarily remove every type of external dependency.

Does breaking an external link remove a clickable hyperlink?
Usually, these are different things. A formula link retrieves workbook data, while a hyperlink opens a location when clicked. Review and remove hyperlinks separately if that is your goal.

Can I break links in Excel for the web?
Link-management options may be more limited or differ from desktop Excel. For a workbook that needs a dependable link-breaking workflow, open a backup in Excel for Microsoft 365 on Windows and use its Workbook Links or Edit Links controls if available.

Safer workflow for a shareable workbook

For a file you plan to send to someone else, keep an untouched working version and make a separate distribution copy. Update the source data and confirm totals in the copy first; then break only the links that should no longer refresh. Check key worksheets, names, charts, and any workbook prompts, save the copy, close and reopen it, and confirm that the figures still make sense. This approach preserves your ability to revise the live workbook while reducing the risk of distributing stale or unexpectedly changing results.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.