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, but I am linking cells from different locations in the Excel file to different locations in a Word doc table. I want all the values to update, rather than having to update individual values.
The idea is, when I drop the Excel file in to the same folder as the Word file, it will update all the values in the Word file.
p.s. I am using MS 365 at work , so I am assuming that these are the latest versions of Excel and Word.
I would appreciate any assistance.
Thank you.
3 Replies
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!
From hazy memory, this is not the way it works. Excel does not PUSH updates into Word, Word PULLS updates from Excel. The way people normally do this in Word is to 1 Press CTRL-A (to select all), 2 Right-click and select "Update Field" from dropdown menu.
That certainly doesn't work on my 365 Business edition. When oh when will MS actually DO SOMETHING about This issue - everyone is having problems with it!
