Shaun,
What you're describing would require relative file paths, which Word's LINK field (used for linking to Excel) doesn't support. However, you can achieve such an outcome with a macro. To see how to do so, check out the macro attached to my post at:
http://windowssecrets.com/forums/sho...External-Files