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.

2 Different Methods to Break External Links in Excel

Method #1 – Copy and Paste as Values

Now paste as values.

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

Method #2 – Edit Options Tab

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

Now we will see below dialogue box.

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

Click on the break link.

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

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

• 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 2 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 –

• VBA Break
• Hyperlink Excel Formula
• How to Create Hyperlinks in Excel VBA?
• Copy Paste in VBA
• Does Not Work in Excel Formula
• Use Analysis ToolPak in Excel
• How to Vlookup to the Left
• How to Insert Hyperlinks in Excel?
• How to Remove Hyperlinks in Excel?