Network Mapped Drive Hyperlinks resolve as UNC in Office Products
Article
Applies to:
Excel 2013, Microsoft Office Excel 2007, Microsoft Office Excel 2007 (Home and Student version), Excel 2010, Microsoft Word 2010, Word 2013OneNote 2013, Microsoft Office Outlook 2007, Microsoft Outlook 2010, Outlook 2013, Excel 2016, Outlook 2016, Word 2016
Symptoms
After a user inserts a hyperlink to a file residing on a network mapped drive within an Office product, the hyperlink's text displays the network mapped drive path, however the link is resolved as the UNC path.
For example, in Excel if you go to Insert, and then click on Hyperlink the user is prompted to select the file. If the user navigates to a file residing on a Network Mapped Drive, and inserts a hyperlink to that file, the hyperlink is created to the file via its UNC path instead of its network mapped drive path. After the link has been inserted, the user can then hover over the link and see that the full UNC path has been used when creating the link to the file.
Cause
The cause is due to the way Office creates hyperlinks to files. Office products create links to files using the UNC path and won't use the network mapped drive location, even if it displays it in the hyperlink text.
Resolution
There's no resolution for this. Microsoft recommends that users insert hyperlinks using the UNC path to prevent confusion in cases where opening a file via UNC or network mapped drive might make a difference in the expected behavior in the file.
More Information
An example of where how a file is opened can be found listed in the following article under the section "Scenarios that may cause links to not work as expected."
Describes a scenario in on-premises Exchange Server and in Exchange Online in Microsoft 365 where users can't use Outlook on the web to open a shared document that resides on a network drive. Provides a resolution.