Forum Discussion
Linked Excel to Word - Word not updating data
Good morning, I have linked a Word and Excel file using the paste link option, however, when I change the data in Excel file, it does not update the Word file. Also, I am not linking an array...
We ran into the same issue—Paste Link can be fragile when you're trying to update scattered Excel data in a Word doc. So we created the Excel-to-Word Document Automation add-in to make the process smoother.
It lets you name tables, charts, text blocks, lists, etc. in Excel and link them in Word. Once it’s set up, any changes in Excel can be updated in Word with one refresh. The best part: the links hold up even if you move, rename, or share the files.
If you’re curious, here’s a link about how it works: https://analysisplace.com/excel-to-word
Happy to share more if it’s helpful!