For the footers on my excel documents, I am requried to include the complete
file path.

When I email the docs to another user, the file path changes. This creates
a problem when I email the docs to the copy center to have them printed. The
temp file location appears and not the original location that our users need
to see at the bottom of the docs.

How can I lock the file location so it doesn't change when emailed?

thanks in advance, jane?