71. Excel Tips - Display Excel File Path

Submitted by Nick on 9 April, 2009 - 08:55

This is an extremely useful tip if you did not already know it:

There's a way in Excel to display the file path of the current open file.
You can add it to your toolbar, and then copy it from there whenever you need it.

Here's a screen shot of our Excel:

display-excel-file-path

Steps to display the file path of the current open file (Excel 2007):

Right click on the ribbon
Choose "Customise quick access toolbar"
Select "All commands"
Then choose "Document Location"
Click "Add".. and it will appear on the right

display-excel-file-path

In Excel 2003, right click on the toolbar, and choose to display "web"

Note: If you have not saved the file, only the workbook name will be displayed.

Download sheet to practise how to Display Excel File Path in Excel

Training Video on how to Display Excel File Path in Excel:

Attachment	Size
display-excel-file-path.xls	27.5 KB

Excel 2007 file path

Submitted by Anonymous on 11 February, 2010 - 07:39.

Thanks for the tip it was very useful.

I succefully added the file path on the toolbar however its not very wide and it shows only the half of the path so to see all I had to select->scroll right/left. At the end I just copied and pasted it to a cell in order to see the full path

It would be nicer if the field was wide enough to showe the full path.

file path

Submitted by Nick on 11 February, 2010 - 14:01.

I don't know of a way to make it bigger..

You might be interested in this instead: excelexperts.com/Excel-Tips-file-path-formula

you can get the file path using a formula, so no copying and pasting needed.

Excel 2007 file path

Submitted by Anonymous on 23 September, 2010 - 08:16.

Brilliant!!!!!
Kudos for the amazing discovery....though i feel microsoft
did mess up abit on their 2007 products.

Display File Path

Submitted by Anonymous on 29 May, 2010 - 18:45.

Congratulations ! I couldn't find the damned thing. I was lost after not finding the 2003 option of Web Address.

Damn Microsoft !

Excel File Path

Submitted by Anonymous on 4 October, 2010 - 15:35.

This was very helpful. thanks a ton!

- Kishore.

Thanks a lot very useful -

Submitted by Anonymous on 19 October, 2010 - 07:46.

Thanks a lot very useful - Rasesh

Display Excel File Path

Submitted by Anonymous on 25 October, 2010 - 10:54.

Thank you Thank You Thank You

question

Submitted by Anonymous on 1 November, 2010 - 22:11.

When you are working in a file, and then save it to a new location, is there a way to get the document location in the ribbon to update? Appears you have to close out of the file and then re-open it.

It's a bug

Submitted by Nick on 2 November, 2010 - 09:24.

Yeah.. that annoys me too.. it's a bug in Excel. Note that if you do the same in Word or powerpoint, it does update.

The only way I have found to make it update is to create a new workbook (CTRL + N), and then press CTRL + TAB to select the old one.

it will then update.

I'll have a word with my insiders at MS..

Command to Display File Path on Toolbar

Submitted by Anonymous on 26 January, 2011 - 13:14.

Oh boy, you guys are life savers. I got a new PC & it wiped out my old set ups. I was going NUTS trying to find this. Never would have guessed that "Document Location" was the command I was looking for. THANK YOU!!

Document location tip

Submitted by Anonymous on 9 February, 2011 - 18:30.

Yes, thanks a lot for the tip!!

Thank you!

Submitted by Anonymous on 2 March, 2011 - 15:39.

I had been looking for this now for over 2 years. This tip made my day.

This feature is gone in Excel 2010

Submitted by Anonymous on 10 March, 2011 - 15:01.

I am using Excel 2010 and now Document Location is missing from the Command list. Is there any way to get it back and/or have the renamed it again?

Web>Address begat Document Location begat ????

full file path

Submitted by Nick on 10 March, 2011 - 23:20.

don't have 2010 yet, but I have a formula that might help you:

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

returns:

Book6.xls

=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

returns:

C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls

having the file path is really useful

You can attach files to emails easily
if you want to open the file in a new Excel session, just copy the file name and go:

Start => Run => type "Excel" paste your path, and wrap it in '

so will look like this:

excel 'C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls'

press Enter

Nick

Excel 2010 - Display File Path

Submitted by Nick on 21 March, 2011 - 17:33.

hi, I just checked, and it works in Excel 2010.
- when you look at the ribbon, there are labels like Font and Alignment... right click on one of those labels to get the option to add the Quick Access Toolbar

Excel 2010 - Display File Path

Submitted by Anonymous on 8 April, 2011 - 17:09.

Thank you Jesus!! :) I have been searching for over an hour for something like this :) Thanks!!

Thank-you, thank-you, a

Submitted by Anonymous on 15 December, 2011 - 05:20.

Thank-you, thank-you, a hundred times. Microsoft have driven me crazy with all the things the 2010 suite won't do!
Dee-Jay

File full path (document location)

Submitted by Anonymous on 31 August, 2011 - 21:28.

Thanks for the long formula on how to display the file full path directory!

I spent hours searching for this!

Pauline

Really handy. Used to have

Submitted by Anonymous on 30 September, 2011 - 15:45.

Really handy. Used to have the ability to display the entire path in the title bar, but MickeySoft, in its infinite wisdom, decided we didn't need that anymore. I think that's called progress.

thank you!!!

Submitted by Anonymous on 12 January, 2012 - 18:59.

that was a beautiful, brilliant formula. So helpful and easy. Thank you!!!
---busy worker bee

and if you just want the path

Submitted by Nick on 18 January, 2012 - 15:21.

and if you just want the path without the file name, use this:

=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

so for this:
'C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls'

it returns this:
C:\Documents and Settings\Any Authorised User\My Documents\

Excel 2010

Submitted by Anonymous on 12 July, 2011 - 15:18.

In the list of All Commands, the file name/path is called "Address".

Thanks a lot, amazingly

Submitted by Anonymous on 27 July, 2011 - 14:15.

Thanks a lot, amazingly simple yet so useful!

document path

Submitted by Anonymous on 7 October, 2011 - 19:16.

After several attempts & looking at various help messages, I noticed that after getting to the customize ribbon and the list of commands you can add, there's another box above it for "all commands". There I found "Document location".

Now, if I could only find a way to have the location automatically be inserted into the workbooks, I'd be happier. Also can't copy into the footer, where I'd prefer it.
Thanks if anyone can guide me on this.

Good site here!!
Sidney

Thanks! That worked for me!

Submitted by Anonymous on 16 January, 2012 - 18:10.

Thanks! That worked for me!

Thank you. Your generosity

Submitted by Anonymous on 5 May, 2011 - 23:08.

Thank you. Your generosity in sharing your knowledge is greatly appreciated.

Absolute Path

Submitted by Anonymous on 5 July, 2011 - 08:04.

Hello Folks,

maybe you can help me a bit here - I also suffered from finding the Web tool bar from 2003 in the 2011 Office. Now I have Document location and I have the link - that works well.
What I still have not found out after hours of search and driving our IT department nuts is the way to display the absolute path.

We are using windows shares and I like to send the location of new files via absolute path, not relative, as you sometime have different mapped drive letters.

Cheers!
Andy

example:

Submitted by Anonymous on 5 July, 2011 - 08:09.

I do not want to see
N:\Templates(Andreas)\newtemplate.potx
but
\\servername\directory\Templates(Andreas)\newtemplate.potx

Cheers!
Andy

Superb site

Aravinda
Singapore

FILE PATH INCL.CELL NUMBER

Submitted by Anonymous on 9 November, 2011 - 03:30.

Does anyone know how to create filepath including cell number?

i want another user to check Cell number that i added in hyperlink.Is it possible???

Excel / VBA Consultancy

Free Training Videos

Free Spreadsheets

Current Excel / VBA Jobs

Excel / VBA Jobs

Navigation

Who's online

New Excel Experts

71. Excel Tips - Display Excel File Path

Last viewed:

Recent Blogs

Forums

Recent comments

User login