Excel 2011 (Mac) - back slashes are changed to %5c in hyperlinks
Posted on 2014-01-24
We have an excel spreadsheet which has a column of hyperlinks that open pdf documents. This file is accessed from both Mac and Windows clients. Just recently the hyperlinks quit working on the Mac clients, giving the error "Cannot open the specified file". Everything still works fine on the Windows clients.
In troubleshooting the problem, I found that when I edited the hyperlink from a Mac, the back slashes in the path were replaced by %5C. Doing the same thing from a Windows client, the path shows the back slash correctly and not %5C. If I try to replace %5C with a back slash \, the Mac will not allow the change to be saved and gives a bonk tone. I can however replace the %5C with a forward slash / and suddenly the link works again, however then I get a popup that says "Some files can contain viruses or otherwise be harmful to your computer".
This file is maintained by someone who uses a windows client. When the back slash is changed to a forward slash from a windows machine, then saved, when you edit the hyperlink again it still shows a back slash. Edited the modified link from a Mac shows the forward slash correctly, as it should.
I do not understand why this problem suddenly popped up. When I search for the above "Cannot open the specified file" I find many instances of this problem going ten years back.
I'd rather not have to manually change every link because there are hundreds, and if I do then I have to deal with the security warning I mentioned. Does anyone know of a way to resolve the "Cannot open the specified file" error without causing the security warning to come up? Or, if there's not a way to avoid that, how can I suppress the virus warning?
Thanks in advance for your help.