ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   file path changes when emailed (https://www.excelbanter.com/excel-worksheet-functions/233236-file-path-changes-when-emailed.html)

Jane

file path changes when emailed
 
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

Dave Peterson

file path changes when emailed
 
Type in what you want.

You don't want to use something that points to the current location.

jane wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com