Break External Links in Excel: Steps and Side Effects

How-to basics · Updated November 21, 2026

To break an external workbook link in Microsoft Excel for Microsoft 365 on Windows, save a backup, open Data > Workbook Links, select the linked source, and choose the command to break the link. Excel replaces formulas that refer to that source with their current calculated values, so the workbook stops updating from it; the change is intended to be permanent, so check the result before saving over your original.

What an external link means in Excel

An external workbook link is a reference from one Excel file to cells or ranges in another file. For example, a formula in a summary workbook might refer to a sales total in [RegionalSales.xlsx]January!$B$12. Excel can use that reference to retrieve a value and, when the source is available, update it. The formula may also contain a full file path if the source workbook is stored in a different folder or shared location.

Links are useful when a report should reflect current information maintained in a separate workbook. They become a problem when the source file is moved, renamed, inaccessible, or no longer needed. A link can prompt Excel to update values when the workbook opens, show a missing-source warning, or leave a report dependent on files that recipients do not have.

“Break link” does not mean removing a clickable web address from a cell. A hyperlink is a navigation target; a workbook link is a formula or other reference that retrieves information from another workbook. Nor is every external data connection a workbook link. Power Query imports, database connections, and other refreshable sources have separate management controls.

What changes when you break a link

For formulas that refer to the selected source workbook, Excel substitutes the formula’s current result and removes the formula. A cell containing ='[RegionalSales.xlsx]January'!B12, for instance, might become the number 42500 if that is the value Excel currently has for the reference. It will no longer recalculate from the source workbook, even if that source later changes.

This is a one-way conversion for the affected formulas. You cannot recover their original formulas simply by reconnecting the source, and Excel warns that breaking links cannot be undone. Treat the replacement values as a snapshot: if the source was unavailable or its latest changes had not been retrieved, the values kept in the destination workbook may not represent the newest source data.

  • Formulas are lost: cells become fixed values rather than live calculations linked to the other workbook.
  • Formatting usually remains: breaking a formula link is not the same as clearing the cell or deleting its formatting.
  • Other formulas can remain: formulas that do not depend on the selected source are not necessarily converted.
  • The source file is not changed: the operation changes the workbook containing the link, not the linked workbook itself.

Prepare a safe copy before breaking links

First decide whether you need a live connection, a fixed snapshot, or a fully self-contained workbook. If other people use the file, check whether they expect numbers to refresh. Breaking a link is appropriate for a final report or archive whose figures should stay fixed; it is usually not appropriate for a recurring report that must pull new data each month.

Use File > Save As to create a separate copy before making changes. Keep the linked original until you have checked the new file. If possible, open the source workbook and let Excel update the destination’s links before breaking them. Review key totals against the source, especially if Excel has displayed an update or missing-file warning. Do not assume that a displayed value is current just because it is visible.

  • Record which workbooks are listed as sources and where they are stored.
  • Confirm whether formulas should become fixed values or remain editable calculations.
  • Check important totals and a few representative linked cells before and after the change.
  • Save the result under a new name, then close and reopen it to see whether prompts or errors remain.

Break a workbook link in Microsoft 365 for Windows

In current Microsoft 365 desktop Excel, the Workbook Links pane is the main place to manage many links to other workbooks. The exact controls can differ slightly as Microsoft updates Office, but the general process is:

  1. Open the destination workbook and save a backup copy.
  2. Select Data > Workbook Links to open the pane. If the workbook has recognized external workbook links, they should appear there.
  3. Select the source workbook you want to disconnect. If there are multiple sources, inspect each name carefully; breaking one source is not the same as breaking all of them.
  4. Choose Break link or the equivalent option in the selected link’s menu, then read and confirm Excel’s warning.
  5. Check cells that previously depended on that source, review important results, and save the copy.

Some older Windows editions show Data > Edit Links instead of Workbook Links. In that dialog, select the source workbook and choose Break Link. If neither command is available, the workbook may have no links of the type that control recognizes, or the Excel version and file state may expose a different interface. Use the checks below rather than assuming that the absence of a button proves there are no external references.

On Excel for Mac, look on the Data tab for Workbook Links or Edit Links; the label and availability depend on the Excel build. Excel for the web has fewer desktop link-management controls, so use the Microsoft 365 desktop app for the break operation if the relevant command is missing. Avoid relying on a keyboard shortcut for this task: the link-management commands are accessed through the Data interface.

Find links and verify what remains

The Workbook Links pane is a useful starting point, but it is not a universal detector for every place a file reference can be stored. Search formulas for the external-reference pattern, commonly a workbook name in square brackets such as [Budget.xlsx]. In Excel for Windows, press Ctrl+F, enter part of the workbook name or .xlsx, select Options, set Within to Workbook, and set Look in to Formulas. On Mac, the equivalent Find shortcut is usually Command+F. Search for a specific source name when possible to reduce unrelated matches.

Search results need interpretation. A file name may appear in a text label or note rather than in a live formula. Conversely, some references are stored outside ordinary cell formulas. Review these areas when you need a thorough cleanup:

  • Defined names: open Formulas > Name Manager and inspect the Refers To entries for paths or workbook names in brackets.
  • Charts: select a chart and inspect its data source or series formulas, particularly if the chart may still use data from another workbook.
  • Data validation and conditional formatting: inspect rules that use formulas or ranges, because references can be embedded in rule settings.
  • Objects and linked content: check inserted objects or other linked items if the workbook was assembled from outside files.
  • Queries and connections: review Data > Queries & Connections separately. A query or database connection is not necessarily removed by breaking a workbook formula link.

After the cleanup, save, close, and reopen the copy. A prompt to update links or a #REF! error is a reason to investigate further, not proof by itself of exactly where the remaining reference is stored. If you must deliver a workbook with no external dependencies, inspect the relevant names, charts, rules, and connections as well as the Workbook Links list.

Common problems and misconceptions

“I broke the link, but Excel still asks to update.” The prompt may be caused by another workbook reference that was not broken, or by a separate connection or linked object. Identify the listed source and inspect the workbook areas above. Removing a workbook link does not automatically disable every kind of external data refresh.

“The link is broken, but the old number is still there.” That is normally the expected result: Excel has replaced the formula with its last available value. The cell no longer knows how to recalculate from the source. If the number is not the one you expected, restore the backup or reconnect the original formula from a reliable source; do not assume that breaking the link will refresh it.

“I want to remove the source from a formula but keep the calculation.” Breaking a link does not preserve the calculation as a local formula; it replaces the whole affected formula with a value. If you want the destination to keep calculating, copy or recreate the needed source data inside the destination workbook and change formulas to use those local cells. Validate the results before deleting or disconnecting the source.

“The link command is unavailable.” The workbook might not contain a recognized link, or its external reference could be in a feature not listed in the link pane. Confirm that you are working in the destination file, inspect the Data tab for the version-appropriate command, and search formulas and names. A hyperlink to a website is handled differently from a formula link to another workbook.

Break links, keep links, or replace them with local data?

Choose based on what the file needs to do after cleanup. Breaking links is simplest when the goal is an unchanging snapshot, such as a final set of reported figures. Keeping links is better when a workbook is designed to refresh from a maintained source and users have dependable access to that file. Replacing links with local data is a middle option when the workbook must remain self-contained but still needs formulas and analysis.

For the local-data option, copy the required source range into a clearly labeled sheet in the destination workbook, then update formulas to refer to that local sheet. This retains calculations that use the copied data, but the copied data will not update automatically. Add a note with the source file and date if readers need to understand where the snapshot came from. For larger or regularly refreshed data sets, a supported query or connection may be more suitable, but it should be managed and tested as a separate data-refresh workflow rather than treated as a broken workbook link.

Frequently Asked Questions

Does breaking an Excel link delete the linked workbook?
No. It changes references in the destination workbook. The source workbook remains where it is and is not modified by this action.

Can I undo Break Link in Excel?
Excel warns that breaking a link cannot be undone. Make a separate backup first. If you already confirmed the operation, the reliable recovery path is to restore the backup or rebuild the formulas from a known-good source.

Will breaking links turn formulas into values?
Yes. Formulas that refer to the selected external workbook are replaced with their current results. Formulas unrelated to that source can remain formulas.

Does Break Link remove hyperlinks or Power Query connections?
Not necessarily. A clickable hyperlink and a Power Query or other data connection are different from an external workbook formula link and may require separate edits in their own controls.

Why does Excel still show an external-link warning afterward?
There may be another workbook source, a reference stored in a name, chart, rule, or object, or a separate connection. Search the workbook and inspect those features, then reopen the saved copy to check again.

Can I break links in Excel for the web?
Some link-related features are available online, but the complete desktop link-management controls may not be. If Workbook Links or the required break command is absent, open the saved workbook in Microsoft 365 desktop Excel and use the Data tab.

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.