Solved

Excel 2010 - show UNC path

Posted on 2010-11-29
7
1,450 Views
Last Modified: 2012-05-10
In Excel 2003 you could get the full UNC path in the web toolbar. How can we get the UNC path in Excel 2010?

Thanks.
0
Comment
Question by:hindersaliva
  • 3
  • 2
7 Comments
 
LVL 3

Expert Comment

by:KevinTHayashi
ID: 34230823
0
 

Author Comment

by:hindersaliva
ID: 34231063
i've seen that Kevin. Excel 2010 has changed further from 2007.
I should be looking for Document Location in 2010, which I cannot find.
0
 
LVL 3

Expert Comment

by:KevinTHayashi
ID: 34231805
I created a short video on how to enable the location bar. Let me know if this helps
KevinTHayashi-374473.flv
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:hindersaliva
ID: 34231979
Kevin,

Thanks for the video.

It shows the drive letter path. What I'm after is the UNC path (eg. \\servername\etc\etc\thisfile.xls ) - to send link by email to colleagues on corporate network who maybe mapped to different drive letters.

Any ideas on this?
0
 
LVL 3

Accepted Solution

by:
KevinTHayashi earned 500 total points
ID: 34232090
If you pull the file from a server location, it should have the UNC path.  Attached is a picture that shows the UNC path when I pulled a document from our SharePoint server.  Is this what you were looking for or am I totally missing the boat here?
Untitled-1.png
0
 
LVL 24

Expert Comment

by:broomee9
ID: 34428890
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
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 …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

706 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

19 Experts available now in Live!

Get 1:1 Help Now