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 files, and many other things. Apart from all these, we can also break these links.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
Click on the break link.
As soon as you click on Break Link, we will see below the 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/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 –
- Hyperlink Excel Formula
- VBA Hyperlinks
- How to Insert Hyperlinks in Excel?
- How to Remove Hyperlinks in Excel?
- Page Setup in Excel
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion