How do I display the full UNC path (i.e. \\server\home\user\filename.xls)
instead of the mapped drive path (x:\filename.xls) in the footer of an excel
(or word) document?

All of our user's home folders are mapped to Drive X and when they put the
path on the footer of the document they are looking on, it shows
x:\filename.xls. It is not a problem if you know who printed the document,
but if you don't, then it is a pain to search for that particular document in
all the users' home folders