Break Links in Excel

How to Break External Links in Excel?

In the excel worksheet, there are two different methods to break external links. The first method is to copy and paste as a value method, which is very simple, and the second method is a little different, you need to go to the DATA tab and click Edit Links and you will find the option to break the link.

Break Links in Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Break Links in Excel (wallstreetmojo.com)

2 Different Methods to Break External Links in Excel

Method #1 – Copy and Paste as Values

Break links Method 1

Now paste as values.

Break links Method 1-1

You can see here that this value does not contain any links. It shows only value.

Break links Method 1-2

Method #2 – Edit Options Tab

The second method is a little different. Go to the DATA tab and click on Edit Links.

Break links Method 2

Now we will see below dialogue box.

edit links

Here we can see all the available external links. We can update the values, open-source files, and many other things. Apart from all these, we can also break these links.

Click on the break link.

Edit links

As soon as you click on Break Link, we will see below the dialogue box.

Method 2-3

Once you break the External link in excel, we will not be able to recover the formulas. So we cannot undo the action once you break the link. This is unlike our Pate Special method.

If you want to break all the links at once, then you need to select all the links and click on Break Links.

Things to Remember/h3>

  • Having links to external sources in Excel is a dangerous thing to have.
  • Once you break the link in Excel, you cannot undo the action.
  • Using *.xl will cover all kinds of file extensions.

Recommended Articles

This has been a Guide to Break Links in Excel. Here we discuss how to Break External Links in excel using two methods, i.e., 1. Copy Paste as Value, and 2. Edit Links Option Tab. along with practical examples. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>