Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»Excel Break Links Not Working? Here’s What Your Should Do

Excel Break Links Not Working? Here’s What Your Should Do

Asmi DhakalBy Asmi DhakalAugust 5, 2022
excel-break-links-not-working

Linking is an effective way to calculate data across multiple workbooks. However, establishing such links may affect your data. Modifying or deleting a linked workbook will drastically change the data on other workbooks. If you’ve landed on this article, you probably understand what we’re talking about.

You understand linking and want to get rid of it but wait, Break Link is doing nothing to de-establish the link! If you received a “We cannot update some of the links in your workbook right now” alert, your workbook isn’t completely de-linked.

This article will discuss why Excel doesn’t break your link and how you can completely break it.

Table of Contents

  • Why is Break Link Not Working?
  • How to Break Links?
    • Unprotect Sheet
    • Inspect Workbook
    • Clear Data Validation
    • Remove Conditional Formatting
    • From Name Manager

Why is Break Link Not Working?

The traditional way of breaking links through Edit Links from the Data ribbon doesn’t work for external links that include Data validation, Conditional formatting, Chart sources, and Defined names. You must manually look for and remove such external links on Microsoft Excel.

If your workbook is protected, Excel won’t break links apart from the specified links. Workbook protection restricts other users from editing certain parts and modifying the contents of the sheets. The solution varies depending on the reason you suspect you’re dealing with. This article will discuss the solution for each of these problems.

How to Break Links?

Break Link normally works for formulas you’ve used to connect workbooks. For more complex entities such as data validation, you’ll have to inspect and remove them from your sheet. There are multiple ways to look for them in Microsoft Excel, so follow the one that’s more convenient for you.

Unprotect Sheet

If the workbook is protected, you’ll have to use the Unprotect Sheet feature on MS Excel. Remember that you’ll need access to the set password to unprotect your entire sheet. Ask for the owner of the sheet for the password and then follow these steps to unprotect it:

  1. Open the Excel document on your device.
  2. Head on to Review from the menu bar.
  3. Locate the Protect section, then select Unprotect Sheet.
    MS-Excel-UnprotectSheet
  4. Enter the set password to confirm your authority.

Inspect Workbook

You can inspect your workbook to check its compatibility. The compatibility checker will list the issues in the workbook. You can additionally prompt it to locate and highlight the problem area in the workbook.

Follow these steps to inspect for problems in your workbook on MS Excel:

  1. Open Microsoft Excel to open your linked document.
  2. Click on File from the menu bar.
  3. From the sidebar on the left, select Info.
  4. Select the Check for Issues option next to Inspect Workbook.
  5. From the drop-down menu, choose the Check Compatibility option.
    check-for-compatibility
  6. In the Check Compatibility window, MS Excel will display all problems with your workbook. 
  7. To locate each problem, select Find next to the problem. You can then clear the problems from your workbook.

Clear Data Validation

You can clear the data source of your data validation from the Data on the menu bar of your workbook. If you suspect the data validation used in your sheet is refraining you from de-linking your workbook, you can refer to these methods to locate and remove data validation on your workbook.

Here are the steps to remove data validation on your workbook:

  1. Launch MS Excel to open your sheet.
  2. From the menu bar, hop on to Data.
  3. Select Data Validation from the Data Tools section in your workbook.
    MS-Excel-DataValidation
  4. On the Settings tab of the Data Validation window, locate Source.
  5. Clear the contents under source and select OK.

Remove Conditional Formatting

If your workbook contains conditional formatting that links it to other workbooks, you’ll have to manually remove it from the Conditional Formatting option on the Formulas tab. Follow these steps to delete the link caused by Conditional Formatting on MS Excel:

  1. Open your workbook from Excel.
  2. On the Home tab, locate the Styles section.
  3. Drop down the menu for Conditional Formatting, then select Clear Rules.
    MS-Excel-ConditionalFormatting
  4. Choose Clear Rules from Entire Sheet.

From Name Manager

You can locate what sheet is linked to your current workbook from the Name Manager tool on MS Excel. You can then delete the named range to remove all links that connect your workbook to other workbooks.

Here are the steps you can refer to delete any link from the Name Manager in your sheet:

  1. Launch Microsoft Excel, then open your spreadsheet.
  2. Head on to Formulas from the menu bar.
  3. Locate the Defined Names section from the ribbon, then select the Name Manager tool.
    MS-Excel-Formulas-NameManager
  4. From the Name Manager window, select the other named range.
    MS-Excel-NameManager-Window
  5. Select the Delete button to remove the linking.
fix
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
Memory-Compression

What is Memory Compression in Windows? Should You Enable or Disable It

March 1, 2023
dism-vs-sfc-vs-chdsk

DISM, SFC, CHKDSK: What’s the Difference

February 28, 2023
bios-settings-for-gaming

Best BIOS Settings for Gaming

February 16, 2023
You may also like
how-to-clean-hp-printer-rollers

How to Clean HP Printer Rollers

March 3, 2023
keyboard input lag

9 Ways to Fix Keyboard Input Lag

March 3, 2023
keyboard key is stuck

How to Fix a Stuck Key on a Keyboard

March 3, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.