How to Break Links in Excel: Step-by-Step

Breaking links in Microsoft Excel removes the connection between your workbook and external data sources, such as other workbooks, so the values become static. This is useful when you want to share a file without exposing its source or when you no longer need the data to update. Before you start, ensure you have the workbook open and that you know which links exist—you can check this via Data > Edit Links.

What You’ll Need

Microsoft Excel (2010 or later; steps are similar across versions)
The workbook that contains the external links
Access to the source files if you want to update links before breaking them

Step-by-Step

Open your workbook in Excel. If you see a prompt asking whether to update links, choose Don’t Update for now—you can update later if needed.
Go to the Data tab on the ribbon. In the Queries & Connections group (or Connections in older versions), click Edit Links. This opens the Edit Links dialog box.
Review the list of links that appears. Each entry shows the source file name and type (e.g., Excel workbook, OLE object). Select the link you want to break.
Click the “Break Links” button in the dialog. Excel will ask for confirmation—click Break Links again to confirm. This converts all formulas that reference that source into their current values.
Repeat for any other links you want to remove. If you have multiple links, you can hold Ctrl to select several at once, but note that breaking them all at once is fine as well.
Close the dialog by clicking Close. Your workbook now has no external references to that source.
Save your workbook to keep the changes. If you later need the links, you’ll have to re-establish them manually.

Common Mistakes

Forgetting to check for hidden links—links can be in defined names, charts, or conditional formatting. Use Edit Links to see all, but also check the Name Manager (Formulas tab) for names that reference external files.
Breaking links when you still need live data—once broken, the values are static and won’t update. Only break when you’re sure you don’t need updates.
Not saving a backup copy—breaking links is irreversible unless you have an original backup. Always save a copy before breaking.
Assuming “Break Links” removes all references—it only affects links listed in the dialog. Links in VBA code or embedded objects may not appear there.

Tips

Update links first if you want the latest values before breaking. In Edit Links, click Update Values to refresh all links, then break them.
Use “Check Status” in Edit Links to see if a link is okay or broken. This helps you decide which to break.
For a quick check, press Ctrl+F and search for the source file name (e.g., “[Book1.xlsx]”) to find formulas that reference it.
If you only want to remove one link from a formula, edit that cell directly and replace the reference with a static value.

Troubleshooting

“Break Links” is grayed out—This happens when there are no external links detected. Check for links in defined names or use the “Find” method to locate external references.
Links reappear after breaking—This can occur if the link is in a chart or a defined name. Check the Name Manager (Formulas > Name Manager) and delete or edit any names that reference external files.
Values change after breaking—When you break a link, Excel uses the last cached value. If the source has changed since the last update, the value may be outdated. Update links before breaking to get the latest.
Error like #REF! appears—This usually means the link was already broken or the source is unavailable. You may need to manually replace the formula with a value.
Can’t find Edit Links—In Excel for Mac, it’s under Data > Edit Links as well. In Excel Online, this feature is not available; you’ll need the desktop app.

Frequently Asked Questions

Will breaking links remove the data?

No. Breaking links replaces formulas with their current values, so the data remains, but it becomes static.

Can I break multiple links at once?

Yes, in the Edit Links dialog, hold Ctrl and select multiple links, then click Break Links.

What if I break a link by mistake?

You can’t undo it, but you can re-link by re-entering the formula or using Paste Special to link again. A backup is the easiest recovery.

Do links in charts get broken too?

Yes, if the chart data source references an external workbook, breaking links will convert the chart’s data to static values.

Why does Excel ask to update links every time I open the file?

That means there are still active links. After breaking all links, the prompt should stop. If it persists, check for hidden links in names or objects.

Can I break links in Excel Online?

No, the Edit Links feature is not available in Excel Online. You need the desktop version to break links.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →