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

Method #1 – Copy and Paste as Values

Now, we must paste them as values.

We 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. In this method, we must go to the “DATA” tab and click on “Edit Links.”

Now, we can see the below-shown 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.

Now, we will click on the “Break Link.”

As soon as we click on “Break Link,” we may see the dialog box below.

Once we break the External link in ExcelExternal Link In ExcelExternal links are also known as external references in Excel. When we use a formula in Excel and refer to a new workbook, it is the external link to the formula. In other words, an external link is when we give a link or apply a formula from another workbook.read more, we cannot recover the formulas. So, we cannot undo the action once we break the link. It is unlike our “Paste Special” method.

If we wish to break all the links at once, we need to select all the links and click on “Break Links.”

Things to Remember

  • It is dangerous to have links to external sources in Excel. Once we break the link in Excel, we cannot undo the action.Using *.xl can cover all kinds of file extensions.

This article is a guide to Break Links in Excel. We discuss how to break external links in Excel using Copy and Paste as Value and Edit the Links Option tab, along with practical examples. You may learn more about Excel from the following articles: –

  • Hyperlink Excel FormulaVBA HyperlinksHow to Insert Hyperlinks in Excel?How to Remove Hyperlinks in Excel?Page Setup in Excel