Rogue links troubling your workbooks. You have visually inspected them and still you have no clue where to find them, then read on…
Approach 1 – Easiest Approach
Bill Manville offers a free Add-in which finds all links given in your Excel. The utility is a very popular one and it should be must have for any Excel enthusiast. The size is very small. At the time of writing this article, the size was < 100 KB. You can choose whether to install FindLink as an add-in so that it is available whenever you are running Excel or whether to just open it when you want to use it
The details of this utility is given at this link –
http://www.manville.org.uk/software/findlink.htm
You can download the link from following location –
http://www.manville.org.uk/software/findlink.zip
Approach 2 – Manual Approach
If you don't want to use add-in, use below article for finding links (This article doesn't take care of Conditional Formatting links which you will have to do manually. Findlink add-in takes care of this aspect also.)