Just a quick thought--what you've been told about working when they're in the same directory applies only if you copy both files to a different folder but the file names stay the same.
To keep links in place even when the file name changes is going to require VBA. I will see if I can research this; meantime somebody else may come in who already knows how.
It's OK to post this in the Excel forum. A better name for your thread would be "Maintain link from Word to Excel even when Excel file name changes"
Bookmarks