How to resolve Break Link not working Issue in Microsoft Excel

Microsoft Excel is a spreadsheet software program that is widely used for managing and analyzing data. It is part of the Microsoft Office suite and provides a range of tools and functions for organizing, manipulating, and visualizing data.Excel allows users to create and edit spreadsheets, perform complex calculations, and generate charts and graphs to help understand the data. Its intuitive interface, support for macros and add-ons, and integration with other Microsoft Office programs make it a versatile tool for many different industries and applications.

In this tutorial we will learn how to resolve the Break Line not working issue in Microsoft Excel.” Break link” in Microsoft Excel refers to the process of disconnecting a workbook from its source data. This is useful when you want to prevent the source data from affecting the workbook or when you want to update the source data without affecting the workbook. There can be many reasons for which the Break Link function is not functioning correctly.

Method 1 : Unprotect the Sheet if it is Protected

Step 1 – Check if the Break Links button is dimmed out

• Go to the Data option in the menu bar.
• Click on Edit Links in the Queries and Connections section.
• Check if the Break links button is dimmed out.

Step 2 – Go to the Review Tab

• Go to the Review tab in the menu bar.

Step 3 – Click on Unprotect Sheet

• Click on the Unprotect Sheet option in the Protect section.

Step 4 – Enter the Password 

• Enter the Password in the Unprotect Sheet dialog box.
• Click on OK

Step 5 – Check If the Break Link function is working

• Go to the Data Tab in the menu bar.
• Click on the Edit Links option in the Queries and Connections Section.
• Check if the Break Link function is enabled.

Method 2 – Change the File Type From .xlsx to .xls

Step 1 – Check if the Break Links button is dimmed out

• Go to the Data option in the menu bar.
• Click on Edit Links in the Queries and Connections section.
• Check if the Break links button is dimmed out.

Step 2 – Click on File Tab 

• Click on the File tab in the menu bar.

Step 3 – Click on Save As

• Click on Save As option.
• Click on the Browse option and select the desired location where you want to save the file.

Step 4 – Change the File Type

• Change the File type to Excel 93 – 2003 Workbook and click on Save button.

Step 5 – Check If the Break Link function is working

• Open the file from the saved location.
• Go to the Data Tab in the menu bar.
• Click on the Edit Links option in the Queries and Connections Section.
• Check if the Break Link function is enabled.