DangerDan88
New Member
- Joined
- Aug 18, 2017
- Messages
- 1
Hi all,
I have an excel file saved on our server that contains hyperlinks to various folders/documents/pdf's across our server, I want to save the excel file to another location on the same server but when I do that the hyperlinks stop working. I've tried changing the hyperlink base to x and the \\(servername) but that didn't do anything.
What I think is happening is that the hyperlinks in the document are all relative, and I'd need absolute hyperlinks if I want to change the path of the excel document and keep the hyperlinks working.
If that is the case, how may I go about changing 200+ hyperlinks from relative to absolute? When I hover
Regards,
Danny
I have an excel file saved on our server that contains hyperlinks to various folders/documents/pdf's across our server, I want to save the excel file to another location on the same server but when I do that the hyperlinks stop working. I've tried changing the hyperlink base to x and the \\(servername) but that didn't do anything.
What I think is happening is that the hyperlinks in the document are all relative, and I'd need absolute hyperlinks if I want to change the path of the excel document and keep the hyperlinks working.
If that is the case, how may I go about changing 200+ hyperlinks from relative to absolute? When I hover
Regards,
Danny