Solved

Excel trusted location cannot take UNC path.

Posted on 2016-07-20
1
72 Views
Last Modified: 2016-07-22
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?

Thanks,
0
Comment
Question by:nav2567
1 Comment
 
LVL 20

Accepted Solution

by:
CompProbSolv earned 500 total points
ID: 41722143
I am running Excel 2013 on Windows 10.  I had no trouble adding a Trusted Location by UNC as long as I have the "Allow Trusted Locations on my network" box checked.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question