File path not working correctly

[Bagia]

Hello,

I would like to put the file/path location (on the network
drive "S") in the footer of each document, however when I email the document,
that path is changed to a path called temporary and the user name of the
person opening the spreadsheet, so that person doesn't know where the
spreadsheet is on the network drive since the path has changed.

If I put the file/path in the header, it remains when emailed, but I
want to have it in the footer. I've been doing that by going to File-Page
Setup-Header/Footer, Custom Header, then clicking the &[Path]&[File]
button. Is there another way to do this so the path remains in the footer
when emailed?

 

[Luke M]

Since the file path of the file wil change when you email it, you may need to
change it to a static value. Why not simply type the file name/path into the
custom footer, instead of using a variable reference?

 

[Bagia]

Thanks for your suggestion Luke. But why does it work in custom header, but
not in custom footer?

Since the file path of the file wil change when you email it, you may need to
change it to a static value. Why not simply type the file name/path into the
custom footer, instead of using a variable reference?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Hello,

I would like to put the file/path location (on the network
drive "S") in the footer of each document, however when I email the document,
that path is changed to a path called temporary and the user name of the
person opening the spreadsheet, so that person doesn't know where the
spreadsheet is on the network drive since the path has changed.

If I put the file/path in the header, it remains when emailed, but I
want to have it in the footer. I've been doing that by going to File-Page
Setup-Header/Footer, Custom Header, then clicking the &[Path]&[File]
button. Is there another way to do this so the path remains in the footer
when emailed?