How to Find, Fix and Remove Broken Links in MS Excel?

Excel Broken Link is when an Excel sheet is linked with different a file which has data like formulas, codes, etc. But if these source files gets deleted, or corrupted then the link which is related to a specific workbook will automatically gets break down. Then these broken links cannot be able to perform their function. And if you want to install Excel application in your device then you should go to the official website of MS Office via office.com/setup.

The causes of the Broken Links in Excel are when the source folder gets deleted and also when the Files/folders shifted to another location. In this blog, you will read how to find, fix and remove broken links in Excel.

Find Broken Links In ExcelWww.office.com/setup

1. Using Find And Replace Method:

First, you have to open your Excel sheet which is showing broken link error. Now, you should press the Ctrl+F button from your keyboard. Here, it will open the Find and Replace dialog box. Now in the open dialog box, you have to go to the Find what box. Then you should enter your file extension which is linked with the cell. After this, in the “within” box option, you have to choose the option “Workbook”. In the Look in box, you should choose the “Formulas” option. At the end, you should press the find all button. Now you will find Excel broken links. After this, you just have to replace the broken link with the correct new link.

2. Through Cell Relationship Diagram:

First, from the menu bar you have to choose the Files and then click on Options tab. Now in the open window, you have to click on the Add-ins tab. Then from the drop-down, you have to choose the COM add-in and then hit on the ok button. In the opened com Add-in dialog box, you should choose the “Inquire”. After this, the tab of Inquire will added in the Excel Ribbon. Now from the diagram group, you should choose Cell Relationship. Then in the next window of the cell relationship diagram will display on the screen. You should choose the options from the opened dialog box and then tap on OK button. Now you will see the diagram on your Excel screen. Here, you can also zoom in to see the links between one cell to another cell, or the link between one cell to another worksheet. Now, you can see cell relationship diagram which has all the included links. In this, you can also check the broken links in your Excel workbook.

Fix Broken Link In Excel:

 For this, first you should take the backup copy of your Excel workbook. Then, open your Excel workbook which has broken link issue. After this, go to the Data tab and then hit on the Edit Links option. If in case, you do not get the Edit Links option this means that your workbook do not have any links. Here from the Source file box, you have to choose the broken link which you require to fix. After this, click on the Change Source option. Now, you have to search the location of the Excel file which has the source of your linked data. Then just choose the new source file and click on the Change Source option. At last, just click on the Close option.

Remove Broken Links In Excel:

First, open the Excel workbook which has the broken link. Then you should go to the Data tab, and tap on the Edit Links button. Now within the Source file box, you should choose the broken link which you want to remove. After this, you have to click on the Break Link button. At last, you should click on the Close option.

For more detail about Excel Application, just go to the site of MS Office via www.office.com/setup

Leave a Reply

Your email address will not be published. Required fields are marked *