Hyperlink in Excel

I have a spreadsheet in Excel 2010, with numerous hyperlinks to documents on my computer. For no rhyme or reason the link keeps breaking. The spreadsheet shows all the necessary details of an existing link (its in blue and underlined) but when selected the computer can no longer open it. This has happened over and over again.

What am I doing wrong??

thank you
Lena