Solved

Excel trusted location cannot take UNC path.

Posted on 2016-07-20
1
58 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Citrix XenDesktop 7.6 Citrix Policies Graphics
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now