I have a folder that contains multiple subfolders. Within each subfolder are multiple Word docs that each contain from 7-25 linked objects from a single Excel file located in one of the subfolders. If it matters, each linked object refers to a single cell reference in Excel (no tables or ranges of data). In other words, the folder is like the one below.
Master File
-Subfolder 1
-Doc A
-Doc B
-Subfolder 2
-Doc D
-Doc E
-Doc F
-Doc G
-Subfolder 3
-Doc I
-Doc J
-Doc K
-Subfolder 4
-Doc M
-Doc N
-Doc O
-Doc P
-Doc Q
-Input.xls

My company distributes a zip file containing the Master File to a few hundred employees. Each employee saves the Master File to their hard drive (to a user-defined folder) and makes a copy of the file for each new customer they have, changing the file name to the customer's name and completeing customer-specific information within the Input.xls for each customer.

When employees open the documents for a new customer, some of the linked objects are populated from the correct Input.xls, while others are (erroneously) populated from the Input.xls located in the original Master File. I've tried to fix this problem by editing ALL of the links (by changing the source) in ALL Word docs within the Master File, but I still find the same link behavior described above when I copy/paste the Master File and set it up for a new customer.

I know I basically just need to be able to set up all the links to be relative, but I can't figure out how to do this. Any ideas about why some docs open and populate links from the correct source file while others populate from the original Master File Input.xls? Anybody know how to fix this? It's costimg me valuable time having to change the sources for multiple files for each new customer. PLEASE HELP!!!

Also, I'm using MS Office 2003.