Forum Discussion
Excel data validation list
Is there anyway to location external links in data validation lists?
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: