View Single Post
 
Old 07-22-2021, 11:41 PM
dtr dtr is offline Windows 10 Office 2019
Novice
 
Join Date: Jul 2021
Posts: 2
dtr is on a distinguished road
Default

The interesting thing is that this approach does not only embeds a range from the Excel but the entire file. If I open the embedded file to edit the values I have access to all the data, even on different sheets.

I plan to provide this Word document as a template to my colleagues. The are supposed to create a copy and fill the relevant parts. If I link the content to an external Excel file my colleagues would have to create a copy of the linked Excel as well and ensure that the Word document is linked to the right Excel file. This is extra work for them and these are extra potential error sources. I like to make their life easier and not harder. Today they have to fill the Word and the Excel file as well as ensuring that they copy past everything correctly. The idea for the future is to have only one file to deal with.
Reply With Quote