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