I am using the Hyperlink function to link to associated documents in my
spreadsheet. The problem comes when trying to copy that worksheet to
another directory or use it from within an email. As the linked documents
are on a network drive, the hyperlink is being saved as
..\..\..\currentdirectory\directoryname

Is there a way to force the hyperlink to be saved as the full destination
path such as e:\usergroup\username\currentdirectory\directoryname?