QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to break Links in MS Excel 2016?

By Neha T Leave a Comment

In the previous article, we learned to create a link in MS Excel 2016. Now if you do not need the links anymore, break the link between the source and referencing workbook. This article explains the steps to break links in MS Excel 2016.

Remember once you break a link between source workbook and referencing workbook, the link/formula will convert to the current value of the cell. And most important this action can’t be undone. So you can save a copy of the referencing file with the new name. So let’s start.

Steps to break Links in MS Excel 2016:

Step 1: Open an Excel sheet of which you want to break links. For demonstration, I have opened a workbook “Links Test“. You can observe in the picture below that selected cell “Garry Lopase” express a link in the formula bar, which expresses that the source of the cell “Garry Lopase” is cell C4 which is in Sheet1 of  Book1 workbook.

how-to-break-links-in-ms-excel-2016-step-1Step 2: Go to the Data tab, there you have a Connections group. Among the buttons present in the Connection, group click on Edit Links button.

how-to-break-links-in-ms-excel-2016-step-2Step 3: An Edit Links, dialog box, will open, which will show you all the links present on your current sheet. Choose which link you want to delete.

how-to-break-links-in-ms-excel-2016-step-3Step 4: The moment you click on the link that you want to delete, all the buttons to the right-hand side of the window will get activated like, Update Values, Change Source, Open Source, Break Link, Check Status.

As the intention of this article is to break links so that we will go with Break Links. Click on Break Link button.

how-to-break-links-in-ms-excel-2016-step-4Step 5: A Microsoft Excel Dialog box will pop-up. It informs that if you break the links the formula and external references will convert to the existing value of the cell. Once you break link it can not be undone, so if you want, save a version of the file with a new name.

To break links click on Break Links.

how-to-break-links-in-ms-excel-2016-step-5Step 6: Remember in step 1 when the cell “Garry Lopase” was selected it shows the source/link/formula in the formula bar. Now when you select the cell “Garry Lopase” it will show the current value of the cell i.e. Garry Lopase.

how-to-break-links-in-ms-excel-2016-step-6

Thank you, Hope the content is useful. Keep reading.

You Might Also Like:

how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? delete blank row feature imageHow to Delete Blank Rows in Excel 2016? how-to-create-links-in-ms-excel-2016-featured-imageHow to create Links in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? Flash Fill in MS Excel 2016How to use Flash Fill in MS Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro in MS Excel 2016? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Check RAM Speed in Windows 10?
  • How to enable right side chat in gmail
  • How to Tag Someone on Instagram Story?
  • How to Install and Use PuTTY to Connect to a Remote Computer
  • How to control your CPU speed using indicator applet in Ubuntu 14.04

Copyright © 2023 · QueHow · Contact Us