The process of embedding an Excel worksheet in a Word document is essentially the same as linking to an Excel worksheet.
It does require a few extra clicks, but it brings all data from the worksheet into your document, not only the selected range.
This works as a one-way link feed that brings the updated Excel data into the linked Word document.
This is a common issue in organizations where documents often contain common graphic elements – examples could include a company’s logo or an organization chart.
For instance, if there’s a reshuffle in the company, updating every single Word document that contains the older version of the org chart may take lot of effort. In the Insert Picture dialog box, click the down arrow next to the Insert button, and then click either “Link to File” or “Insert and Link”.
That’s where this “Insert and Link” command comes in handy.
It’s like saying – link to the selected picture in the Word document but, to be on the safer side, also embed a copy of image so that if the original source file cannot be located, the recipients can still see the picture in the document.
”See Word 2013 – How to link an Excel spreadsheet to see how these documents are linked.
Issues can occur when the linked file has been moved or delete.
Convert Linked Images to Embedded Images If you are sharing documents externally, the “Insert and Link” approach should be preferred over “Link to File”.
However, if there’s a Word document that contains only linked images and you want to upload it to Google Docs, the first thing you need to do is convert these “linked” pictures into embedded graphic.
So if you edit the linked picture, the change is reflected immediately in all the Word document(s) that use that picture.
Option #2 – Insert and Link: The drawback with the “Link to File” approach is that if you upload the document onto the web or share it via email, the recipient won’t see any of the pictures as the links have broken.
The difference is that it opens a blank Excel worksheet for you to fill out.