Want to check Hyperlink that opens PDF file saved on Server.

[Jamber89]

I have over 5,000 and continually adding hyperlinks in my excel document. These links once clicked on open a PDF file that is saved on my server. I was wondering if there was a way to check the hyperlinks to see if they are broken instead of clicking on each one. I use this formula to create my hyperlinks.

=HYPERLINK("X:\Released Drawings\"&J:J&"\"&C4&".pdf",C4)

Any help would be grateful.

Thanks,
Amber

 

[Jamber89]

Thanks you that worked like a charm.