hello all. I just had a question and am trying to figure a solution. A user wants to share an Excel file that has hyperlinks to other files with several users. some of these are from outside of the company so saving this to a network share is not an option.

When the file is moved from PC to PC, the location can change even if placed in My Documents folder. Is there any way that I can set it to either have a wildcard in place for the username or if there is a code I can add that will update the location?