?
Solved

Excel trusted location cannot take UNC path.

Posted on 2016-07-20
1
Medium Priority
?
135 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 2000 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Suggested Courses

752 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