Linking to other workbooks is a very common task in excel but sometimes you might find yourself with a workbook that has links you cant find even though excel tells you they exist. There are several ways to find external links and broken links in workbook some are easy to use but have limitations i will talk about each method in this article.
There are a few ways to locate these links and remove them if desired.
Find external links in excel 365. With more than 300 handy excel add ins free to try with no limitation in 60 days. Microsoft excel find links external references in a workbook linking to other workbooks is a very common task in excel but sometimes you might find yourself with a workbook that has links you cant find even though excel tells you they exist. With kutools for excels find and break broken links you can find all the external links of the active worksheet at the same time you can break the specific links as you need.
Cells with external links contain the name of the workbook to which it links. Microsoft does not have any inbuilt function that can find external references or links but still there do exist some workarounds to do this. Here are the steps to find external links in excel using find and replace.
Kutools for excel. See what jacob at vbax has to say about this advanced topic. How to find external links or references in excel manually finding external links or references in a spreadsheet is a cumbersome task.
How to remove links from excel that no longer exist january 13 2015 january 13 2015 if when you open and excel workbook you receive an update links message but the linked source no longer exists you have a problem. There is no automatic way to find all external references that are used in a workbook however there are several manual methods you can use to find them. We can use this to find all the external links.
This would mean that the reference would have the file name with xlsxxlsxlsmxlb extension. Note that this article writes about file link not hyperlink. Find external links using find and replace.
Adin post ad using the find feature a quick way to cycle through your external links depending on the number you have is to use the find feature built into excel. Excel find all external links and broken links in workbook.