Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to easily get network path to the file you are working on?

In Excel 2003 there used to be a command that I added to my toolbar that was called Address (if I remember correctly) and it would show the fully-qualified network path to the file I had open. For example: \\ads\IT-DEPT-DFS\data\Users\someguy\somefile.xls

This made it easy to grab this string and pop it in an email when you wanted to share the file with a coworker. I don't see this option in Excel 2010 but find myself needing to send/receive Excel files a lot now. Coworkers will give vague references to "it is on the share drive" or email the file as an attachment (ugh!).

Anyone know if something comparable exists in Excel 2010?

UPDATE: I found this mapping of Excel 2003 to 2007 commands. http://office.microsoft.com/en-us/excel-help/redir/AM010186429.aspx?CTT=5&origin=HA010086048

Web>Address is what I was using - looks like that became "Document Location" in 2007. But they removed/obfuscated this again in 2010. I am trying to find a mapping like this for 2007 to 2010.

like image 495
indyDean Avatar asked Mar 10 '11 14:03

indyDean


2 Answers

Right click on the ribbon and choose Customize the ribbon. From the Choose commands from: drop down, select Commands not in the ribbon.

That is where I found the Document location command.

like image 27
Richard Wood Avatar answered Oct 11 '22 06:10

Richard Wood


I found a way to display the Document Location module in Office 2010.

File -> Options -> Quick Access Toolbar

From the Choose commands list select All Commands find "Document Location" press the "Add>>" button.

press OK.

Viola, the file path is at the top of your 2010 office document.

like image 82
DarthPaper Avatar answered Oct 11 '22 07:10

DarthPaper