Forum Discussion
Excel data validation list
Is there anyway to location external links in data validation lists?
External Links can reside in Data Validation rules. This can occur as the Source input for a List rule. You can manually search through each of your Data Validation rules within your workbook however, that may be a daunting task if you have a lot of tabs to search through.
Exactly! I'm hoping there is a way, even if it is VBA, to find the cell locations of the external references in the data validation lists because it is so time consuming to go into each cell and review them. It is quick to search for external links in cells and range names but the I'm using a lot of lists on my file. I need to copy from other files from time to time which sometimes creates file links in the data validation lists but it is impossible to locate where. Thanks in advance for any help.
Haven't tried myself but this has come up here before. Try the product in this link:
