How to Find and Break Broken Cell Links in Excel

Do you see an update links warning every time you open an Excel workbook? This often happens when some formulas still refer to another workbook that has been moved, renamed, deleted, or is no longer accessible. These invalid formula references are known as broken cell links.

In this tutorial, you will learn how to find and break broken cell links in Excel step by step. First, we will use Excel’s built-in tools to find external links in formulas and break workbook links. Then, we will show a faster way with Kutools for Excel, which lets you filter the link type to Cell, review the linked records, and break selected cell links more easily.

• Why update link warnings appear and what to check first
• Method 1: Find and break broken cell links with Excel built-in tools
• Method 2: Quickly find and batch break cell links with Kutools
• Excel vs. Kutools: which method should you use?
• What if broken links still remain?
• Frequently asked questions

Why update link warnings appear and what to check first

Excel may show an update link warning when a formula in your current workbook refers to a cell or range in another workbook, but Excel can no longer update that source file. This kind of invalid external formula reference is often called a broken cell link.

For example, a formula may contain an external workbook reference like this:

This link may become broken when the source workbook is deleted, renamed, moved to another folder, stored on an unavailable network drive, or copied from another computer. When that happens, Excel may keep asking you to update links, return errors, or leave formulas connected to a file you no longer need.

Broken cell links are especially common in monthly reports, sales workbooks, financial models, copied templates, and files shared between different team members.

Before you break these links, check what you really want to do:

• If the source workbook still exists but was moved or renamed, use Change Source to reconnect the formulas.
• If the source workbook is no longer needed, use Break Links to remove the external connection.
• If you are not sure, save a backup copy before making any changes.

Method 1: Find and break broken cell links with Excel built-in tools

Excel’s built-in Workbook Links pane lets you manage and break links to other workbooks. This method is useful when you only need to remove a few external workbook links and do not need a detailed filtered list of individual cell links.

1. Open the workbook that contains the broken cell links.
2. Open the Workbook Links pane using one of the following ways:
   • If Excel shows an update link warning bar, click Manage Workbook Links.
     
   • Or go to the Data tab, then click Workbook Links.
     
   • In some older Excel versions, click Data > Edit Links instead.
3. Find the source workbook with a warning sign. Click the More Commands button, usually shown as three dots, next to that broken source workbook. Select Break links.
   
💡Tip: A warning sign usually means Excel cannot update the link because the source file is missing, moved, renamed, or unavailable. Avoid clicking Break all unless you are sure you want to remove every workbook link. Some normal workbook links may still be valid and should not be removed by mistake.
4. Confirm the operation when Excel asks you to continue.
   
5. Save the workbook.

Result: The selected broken workbook link is removed. Any formulas that referred to that source workbook are usually replaced with their current calculated values, so the workbook no longer depends on the missing or unavailable file.

Method 2: Quickly find and batch break cell links with Kutools

When a workbook has many external references, finding the exact linked cells manually can be slow. Kutools for Excel makes it easier with the Find and Break Broken Links feature: list detected links, filter them by Cell type, review the results, locate linked cells, and break selected cell links in one place.

1. Open the workbook that contains the broken cell links.
2. Click Kutools > Link > Find and Break Broken Links.
   
3. In the Find and Break Broken Links dialog box,
   1. Open the In worksheet drop-down list and select the worksheet or worksheets you want to check.
   2. Open the Type drop-down list and select Cell.
   3. All external links are listed and checked, and records filled with grey indicate invalid links. Open the Status drop-down list and select Invalid to select only the broken cell links.
   4. Click Break Links to remove the selected cell links.
      

Result: Kutools breaks the selected cell links and shows which linked records were processed in the dialog box. Any formulas that referred to the broken source workbook are usually replaced with their current calculated values, so the workbook no longer depends on the missing or unavailable file.

Excel vs. Kutools: which method should you use?

Both methods can help you deal with broken cell links, but they are better for different situations. If you only have one or two source workbooks to remove, Excel’s built-in tools may be enough. If you want to quickly filter, review, locate, and break many cell links, Kutools is more convenient.

Frequently asked questions

What is a broken cell link in Excel?

A broken cell link is a formula reference to another workbook that Excel can no longer update. This often happens when the source workbook is moved, renamed, deleted, or stored in a location that is no longer accessible.

How do I know if a formula contains an external link?

External workbook links usually include another workbook name in square brackets, such as [Sales.xlsx] or [Budget.xls]. In Excel, you can press Ctrl + F, search for .xl, set Within to Workbook, and set Look in to Formulas. With Kutools for Excel, you can use Find and Break Broken Links and select Cell in the Type drop-down list to list external links stored in cells more directly.

What happens when I break a cell link?

When you break a workbook link in Excel, formulas that use the source workbook are usually converted to their current calculated values. This removes the connection to the external file, but it may also remove the original linked formula.

Can I undo broken links?

In desktop Excel, breaking workbook links may not be undoable. That is why it is safer to save a backup copy before breaking any links.

Why does Excel still show external links after I break cell links?

The remaining links may be stored outside normal worksheet formulas. Check defined names, PivotTables, shapes, text boxes, charts, and other workbook objects. For hidden name links, you can use a separate method to find and break broken name links in Excel.

Can Kutools find only cell links?

Yes. In the Find and Break Broken Links dialog box, choose Cell from the Type drop-down list. Then Kutools displays only the external links stored in cells from the selected worksheets.