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? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016? how-to-use-vlookup-in-ms-excel-2016-featured-imageHow to use VLOOKUP in MS Excel 2016? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016? how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro 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 Deactivate Account in Instagram?
  • How to Download Private Instagram Stories?
  • How to Slow Motion a Video in PowerDirector?
  • How to Check Who Unfollow You On Instagram?
  • How to Use Boomerang on Instagram?
  • How to Edit Video in PowerDirector?
  • How to Mute Someone’s Stories or Posts on Instagram?
  • How to Hide and Unhide Posts on Instagram?
  • How to Change Video Background in PowerDirector?
  • How to Make a Video Call on Instagram?

Related Searches

  • How to Host a Meeting in Zoom?
  • How to Post a Picture on Instagram from PC?
  • How to Upload in OneDrive?
  • How to Add Read More Button in WordPress
  • How to add background image in PDF

Copyright © 2021 · QueHow · Contact Us