Excel 2007 file path name how to.

[MarieTherese]

Hello There,

Can someone tell me how to get the file path name showing in excel 2007.
I've looked in the customise quick access toolbar but can't find the web option you could get in excel 2003 which shows the full path name address of the document you're working in.

Thanks in advance,

MT

 

[JPM]

Type this formula to show the current file name, its full path, and the name of the active worksheet:

=CELL("filename")

Also, Excel's help files show various other options. Just search for 'file name'

 

[MarieTherese]

This works a dream thank you.