Forum Discussion

Copper Contributor

May 08, 2019

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...

excel

seanrm100_

Copper Contributor

Jun 17, 2019

Does anybody have experience with this?

Twifoo

Silver Contributor

Jun 18, 2019

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.

seanrm100_
Copper Contributor
Jun 18, 2019
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.
- nroyheppell
  Copper Contributor
  Jun 15, 2021
  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