Fix: Excel file will not break links

Matthew Adams
by 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 surrounding it. He is passionate about... Read more
Affiliate Disclosure
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

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 can’t break all spreadsheet links with the Edit Links dialog. If you can’t break all reference links in an Excel file, check out some of the resolutions below.

How can I break links when the Edit Links dialog doesn’t break them?

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. Click the Data tab.
  3. 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.

4. Check out the Break Link Excel add-in

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 that when you can’t get rid of them with the Edit Links tool. Note that spreadsheet objects and pivot tables might also include reference 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.

RELATED ARTICLES TO CHECK OUT: 

This article covers:Topics: