Forum Discussion
Linked Excel/Word Template?
Hey there, I was wondering what the best practice is for dynamically linking certain tables from an Excel book to a Word doc, then copying both the Excel book and Word doc to new files, while mai...
I suggest that you save both Excel and Word files in the same folder. Also, ensure that the paste link in the Word file is updated to reflect the new location of the Excel file.
What if there are like 100 links? Using the links manager I can update the file one by one, but it seems buggy and some of them start pointing to the wrong table. Is there any way the links can just be a relative location instead of absolute? As in link to a file called "ExcelInput.xlsm" in the same folder as the word doc. Then when you copy both to a new folder and leave the excel name alone it would keep the links but look for the excel file in the same folder.
seanrm100_ Hey Sean, I'm having the exact same issue as you did. I'm trying to link my Word template to my excel file data but I have to update my connections for each new report, which eliminate the benefits of linking data in the first place. Have you found a solution?
Thanks,
Nicolas
