Solved

Excel 2010 - show UNC path

Posted on 2010-11-29
7
1,471 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

773 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