Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel 2010 - show UNC path

Posted on 2010-11-29
7
Medium Priority
?
1,501 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
[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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 2000 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:Tracy
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

636 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