I have an Excel 2011 spreadsheet set up and every hyperlink I have that points to a file on the server works when I initially set it up, but subsequently every time I click on the hyperlink I get the message "cannot open the specified file".

I have checked and I am connected to the server and the file is in the correct location.