Hello All,
I'm working on a project that requires me to hyperlink thousands of sources to an external (on-line) database.
When opening this specific workbook, excel sends this message appears:
2.PNG
Then, upon further investigation I can view the links that are causing the problem:
3.PNG
I have tried using a macro from another post to identify broken links but this didn't work.
http://www.excelforum.com/excel-prog...ken-links.html
Is there anyway of searching for the text in a hyperlinked cell?
Thanks
Bookmarks