xl2002+ has the ability to include the full path in the header/footer.
Before that, you can do it manually or by using a macro.
John Walkenbach has a utility that can write that macro for you:
http://j-walk.com/ss/excel/files/addpath.htm
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Matthew Connellan wrote:
The sixth includes hte file name, but I want the whole network path. Word
uses a field: {FILENAME /p} to automatically insert this info. Does Excel
have a similar capability?
"Rae Drysdale" wrote:
Yes, in the header/footer go to custom and there you'll find a lot of options
on the buttons. The 6th and 7th buttons are the ones you want. Hope this
helps.
--
Rae Drysdale
"Matthew Connellan" wrote:
Work uses 'autotext' to show this data. Does Excel have a similar function?
--
Dave Peterson