Relative hyperlinks broken for Office 365 Excel
The newest two updates to Office 365 (16.9 & 16.10) broke the way that relative hyperlinks work in Excel for Mac.
As an example, if you have documents located in a folder called "Documents" and try to create a relative path hyperlink "Documents/some document", Excel can no longer follow the hyperlink path, and returns "Cannot open the specified file"
This does not happen on older versions of Excel for Mac, or on Excel for PC. This has created a huge problem in my office, where we have hundreds of Excel documents with thousands of PDF links connected this way.
Please fix this new "update"
Hi everyone – thanks for reporting this issue. It has been fixed and you can read more details about it here – https://support.office.com/en-us/article/problem-opening-files-or-folders-via-hyperlinks-in-excel-2016-for-mac-9a0c8216-e702-438a-86a1-028d6499e3c2?ui=en-US&rs=en-US&ad=US.
Steve K – MS Excel
Marie Updegrove commented
Steve, I have the same problem with Windows. Is there a fix?
Davide Paterlini commented
This problem caused a huge impact on my activity, please FIX IT ASAP...
NEED A FIX ASAP...
My observation: This is not a problem on PC... only a problem on MAC
I encountered the same problem, please fix this issue