External Links Report Add-In

External links report add-in

by Anurag Kushwaha
Financial modeller & VBA ExpertFollow

7 reviews486 views|Start the discussion!|Bookmark download for free

Description
Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.

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. You need to look in
a) formulas,
b) defined names,
c) objects (like text boxes or shapes),
d) chart titles, and chart data series.
e) conditional formats
f) data validations

It is always not easy to find such links. In a financial model these links can threaten model integrity usually causing non-responsiveness to input changes in the output.

Using the add-in is easy and it allows you to find the exact cells with addresses, named ranges, chart objects, etc. The add-in reports all such instances in a tabular format in a separate sheet.

This Best Practice includes
1 excel addin (.xlam file)