WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Break Links in Excel

Break Links in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

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

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.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

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 –

  • Hyperlink Excel Formula
  • VBA Hyperlinks
  • How to Insert Hyperlinks in Excel?
  • How to Remove Hyperlinks in Excel?
  • Page Setup in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More