I have Excel installed on a Windows 2012 RDS server. The server also contains a share drive which contains the user data in a centralized location.
I go to Excel trusted location - file>option>trust center>trust center setting>trusted location, and enter the UNC path of the share drive (which is locally on the server - \\myserver\userdata). I drop a protected worksheet in the share and open it from there. I still see the worksheet is opened in protected view.
I then go back to update the trusted location with drive letter path - c:\userdata, the document is opened normally.
Anyone knows if UNC path be used when adding a trusted location?