show the URL of file

[learn]

I need to show the URL or path of my excel file in the file working it, like C:\Users\noud\Desktop\folder3\excel

 

[Useful]

Hi right click on file go to properties and you'll be see it

 

[Sandeep Warrier]

Hi & welcome to the Board!

If you use Excel 2003, then you can go to View | Toolbars | Web. This will display the path of the file.

For Excel 2007, right click anywhere on the ribbon. Click Customize Quick Access Toolbar. Choose All Commands from the drop-down and Choose Document Location. click Add. Close the options window.

Same in Excel 2010

 

[Sandeep Warrier]

Hi

If the file is saved, then you can use this formula in any cell within your print area.

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

 

[HugeElvis]

I added the document location and it works. However, it does not stay on the ribbon. Do I have to add the document location to every file or is there a way to make it "stick"
Thanks