Hi,
One of the guys here at work is having a bit of a problem.
He has just recently upgraded to a new computer and Windows 7 and Office 2010. Since then when he opens a shared spreadsheet and clicks on any of the links it says "Address is not valid" and he has to go in and copy and paste the address all over again just to make it work.
As the workbook has over 500 different hyperlinks, he doesn't really have the time to go into each one and change it.
However when I open the file, or anyone else in the office opens the file it works fine?? Even through remote desktop
Does anyone know why this is happening to him and is there an easier fix than redoing every single hyperlink?
Thanks very much.
One of the guys here at work is having a bit of a problem.
He has just recently upgraded to a new computer and Windows 7 and Office 2010. Since then when he opens a shared spreadsheet and clicks on any of the links it says "Address is not valid" and he has to go in and copy and paste the address all over again just to make it work.
As the workbook has over 500 different hyperlinks, he doesn't really have the time to go into each one and change it.
However when I open the file, or anyone else in the office opens the file it works fine?? Even through remote desktop

Does anyone know why this is happening to him and is there an easier fix than redoing every single hyperlink?
Thanks very much.