Thread: [Solved] MS Word and Excel Data Link
View Single Post
 
Old 03-31-2014, 01:11 PM
MDBeets MDBeets is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Mar 2014
Posts: 3
MDBeets is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
You can do that by right-clicking on the linked object, then choosing Linked Worksheet Object>Links>Change source.
The problem I see with this is I will have to update each link in each document every time I copy the master folder to a new project folder. It's like I am fighting a absolute reference point when I need it to be a relative reference point.

each time I copy the master to a new folder, I need the word worksheets to look at the new excel worksheet which was copied at the same time within the original master folder.

Does this make sense?
Reply With Quote