How to Fix Excel Break Links is Not Working? [Simple Guide]

Use there quick fixes to get back to work in no time

by Matthew Adams
Matthew Adams
Matthew Adams
Windows & Software Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things... read more
Affiliate Disclosure
  • Excel brings lots of functions that help us get our work done as fast as possible, but when the function we need doesn't work it can be really annoying.
  • Such a function can even be the Excel break links that if it's not working can really be a pain.
  • Fortunately, this article shows you exactly how to make it work again in a matter of minutes.

To fix Windows PC system issues, you will need a dedicated tool

  • Download Fortect and install it on your PC
  • Start the tool's scanning process to look for corrupt files that are the source of your problem
  • Right-click on Start Repair so the tool can start the fixing algorithm
Download Now Fortect has been downloaded by 0 readers this month, rated 4.4 on TrustPilot

Some Excel users link their spreadsheets with reference links. A value in one Excel file will then be linked to another. Users can usually remove those reference links with the Edit Links dialog, which includes a Break Link option.

However, sometimes users encounter an error where the excel function to break links is not working. If you can’t break all reference links in an Excel file, check out some of the resolutions below.

In this article

1. Unprotect the Excel worksheet

  1. Select Excel’s Review tab.
  2. Click the Unprotect Sheet button.The Unprotect Sheet button excel file will not break links
  3. If the sheet protection has a password, you’ll need to enter that password in the dialog window that opens.
  4. Click the OK button.
  5. Then the Break Link option might not be greyed out. Select the Data tab.
  6. Click the Edit Links option.Edit Links option excel file will not break links
  7. Select the links listed, and click the Break Link option.

2. Delete named cell ranges

  1. Click the Formulas tab.
  2. Press the Name Manager button.Name Manager window excel file will not break links
  3. Select a cell range name there.
  4. Press the Delete button to erase it.
  5. Click the OK option to confirm.
  6. Delete all the referenced cell range names listed within the Name Manager.
  7. Click the Close button.

3. Clear all data validation rules from the sheet

  1. Click the Select All button at the top left of a worksheet.
    Select All button excel file will not break links
  2. Select the Data tab.
  3. Then click the Data Validation button.
  4. Select the Data Validation option.
  5. A dialog box should then open that asks to clear all.
    • Press the OK button on that window.
  6. Repeat the above steps for other sheet tabs in the spreadsheet.

The Break Link Tool is an Excel add-in with which you can quickly remove all reference links from an Excel worksheet. The add-in is not freely available, but you can still try out the add-in with a one-week free trial.

Click the Download button on the Break Link Tool page to install that add-in.

With that add-in installed, you’ll see a Break Links button on the Home tab. Click that button to open the tool’s window. Then you can click a Select all option to select all the tool’s break link settings. Pressing the Start button will remove all the links.

So, that’s how you can break links in your sheet when you can’t get rid of them with the Edit Links tool. Note that spreadsheet objects and pivot tables might also include referral links.

So, also check if any objects and pivot tables on sheets have any reference links.

Which one of these methods worked out for you? Let us know by leaving a message in the comments section below.

This article covers:Topics: