After that in the box of Look in you have to choose the “Formulas” option.Īfter performing these steps, you will easily get Excel broken links.Now in the “ within” box option, choose the option “ Workbook”.Here you have to enter your respective file extension which is linked with the cell. In the opened dialog box of find and replace go to the Find what box.This will open the Find and Replace dialog box. After that press the Ctrl+F button from your keyboard.First of all, open your Excel sheet which is showing broken link issues.So when the source file is relocated or deleted from the device then the worksheet starts showing Excel broken link error.įollow the below-given steps to find broken links in Excel: This extension signifies that the source file is linked with that respective cell. When the link is created with the source file each worksheet cell obtains a unique file extension. The easiest way to find Excel broken links is by using the Find and Replace method of Excel.
How To Find Broken Links In Excel? Method 1# Using Find And Replace Method
Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.