Adding path to Excel footer 1

[mhoyt]

Among the built-in options for Excel footers is the filename and tab description. I like to put those in each of my document so people can find the file again later.

But it is not always obvious which network directory contains the file so I'd like to add the full pathname to the footer. Is there any way to do this short of typing it in?

TIA Mike

 

[VulcanJedi]

&[Path]&[File]

in the footer? does this not work ?

Tranpkp

 

[mhoyt]

Not on my machine. I get

Path]filename.xls

Adding an equals sign at the beginning, or a space between the two functions(right term?) does not help either.

 

[cheerio]

Not quite what you wanted but you could put into cell A1
=CELL("filename")
and then set row 1 to repeat on every page.

 

[VulcanJedi]

i did this on a network drive at our place and it worked for me fine.

Tranpkp

 

[chris0427]

For Excel 2000, one way to add the full path to the footer is with programming:
See

http://support.microsoft.com/kb/213615

- How to add the workbook path to the footer in Excel 2000

In later versions of Excel, there is a button in the Headers/Footers section to add the path name.

 

[mhoyt]

Ah Chris! Sweet! Works like a charm. Thank you!