Automatic Hyperlink to File Location/Path on Server

Is there a way to format Excel and other MS Office documents so that when you open a new document and save it somewhere on a server, the hyperlink to that specific file location (path) appears in the footer of the document?

Also, if files were to be re-organized on the server, is there a way to have this hyperlink automatically modify to match the new file location/path?