Hi all,
I know this might be the wrong forum to post in as it is kind of regarding Word aswell.

my question is whether it is possible to have the relative path of the linked worksheet rather than absolute path?
I want to be able to copy a word document and the linked excel workbook and paste into new directory folders etc, but the word document maintains the original absolute excel workbook path.

thanks in advance,
Matt