MS Word and Excel Data Link
In my job I prepare bid packets which contain multiple documents (12-18 different word documents) which must be filled in with the same data. I was tired of opening each document, filling in each blank with the correct information and ensuring I have the correct information in each document. I created a master folder which contained all these documents and a single excel spreadsheet I titled "Bid Information". I then copied links from the excel into each word document where information is changed so i update the excel sheet and the link fills in the blanks on all sheets. My thought was I would copy the master document folder into a new project folder and change the information on the new excel sheet. Here is my problem; my word document still references back to the original (master) excel sheet and not the copied excel file in the new project folder. Is their a way to make these documents tie to the new copy rather than the original? Thanks for your help!
|