Elite Membership

Break Links in Excel

Written by Jeevan A Y Jeevan A Y Freelance Writer Jeevan, a seasoned data expert with 7 years in MIS reporting, excels in Advanced Excel, VBA, Power BI, and SQL. Currently an Assistant Manager MIS, his insightful data storytelling drives swift decision-making. 7+ years of experience MBA (Finance & Marketing) MIS Reporting View Full Profile
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Content Reviewer & Course Director Dheeraj is a former J.P. Morgan and CLSA Equity Analyst with nearly two decades of experience in financial modeling, valuation, equity research, and corporate finance. He specializes in helping students and professionals develop practical and in-demand finance skills through structured and AI-powered, 20+ Years of experience CFA, FRM, IIT Delhi, IIM Lucknow Financial Modeling View Full Profile
Updated Dec 19, 2024
Read Time 2 min

There are two different methods to break external links in the Excel worksheet. The first method is to copy and paste as a value method, which is very simple. The second method is a little different. First, we need to go to the “DATA” tab and click “Edit Links,” and find the option to break the link.

Break Links in Excel

Method #1 – Copy and Paste as Values

Break links Method 1

Now, we must paste them as values.

Break links Method 1-1

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

Break links Method 2

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

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

Edit links

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

Method 2-3

Once we break the External link in Excel, 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: –