Solved

Excel trusted location cannot take UNC path.

Posted on 2016-07-20
1
100 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

732 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