I have created an excel document with hyperlinks to other documents on our drive. For some reason when I click on the links i get the above message. But the file pathway that is correct.

I have over 200 link and do not want to enter them in again manually.

PLease help

• Edited by MichaelaH1981 Friday, March 06, 2015 4:16 PM

Hi,

I am guessing that you are linking to 'other' Excelfiles right? How did you create the hyperlinks?

Maurice

Hi,

Which version of Excel are you using?

Have you changed the file path where the linked documents are saved?

If we manually modify a problematic link, will it work correctly then?

Please also check the following setting of your Excel. Click File > Options > Advanced, scroll to the General section, then, click the Web Options button. Make sure the check box before "Update links on save" is not checked under Files tab.

In addition, we may consider to use VBA code to refresh/update your hyperlinks to see if it will make any difference. Since we are not the best resource for coding, you can post coding related question in the following forum:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

Thanks for your understanding and support.

Regards,

Steve Fan
TechNet Community Support