Thread: [Solved] MS Word and Excel Data Link
View Single Post
 
Old 03-28-2014, 07:10 AM
MDBeets MDBeets is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2014
Posts: 3
MDBeets is on a distinguished road
Question 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!
Reply With Quote