Solved

Excel trusted location cannot take UNC path.

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

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

685 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