I received a USB drive from a client with an Excel spreadsheet with hyperlinks to PDF's (not sure of the version it was originally created in but my version is 2007). The PDF's are in another folder on the USB drive. The cells with the hyperlinks have a formula to hidden cells [i.e. =HYPERLINK(C17,B17)] - in column B is the name of the hyperlink and in column C looks to be the file trial to the PDF (please see attached picture). When I select the link, I get an Alert Box stating, "Cannot open the specified file." Do you have any idea of how I can get these links to work? Thanks!
Excel Hyperlinks.png
Bookmarks