Errors with Hyperlinks - unable to open files

[Bmorrison21]

I have an excel spreadsheet with link to over 100 files. Some of the links do not work, and some links that are in the spreadsheet multiple places in the spreadsheet work in some cells and in other cells the same link will not work. I have tried to delete the hyperlink and insert it agian but it still will not work.

Any tips for trouble shooting hyperlink error of this nature? Do the documents that i am linking to need to be in a curtain format, and are there cell formats that would cause a hyperlink not to work?