When you embed an Excel object, information in the Word file doesn't change if you modify the source Excel file. Linking is also useful when you want to include information that is maintained independently, such as data collected by a different department, and when you need to keep that information up-to-date in a Word document. Locate and select the desired Excel chart, then click Insert. Select the Create from File tab, then click Browse. Click the Object command in the Text group. Use linked objects if file size is a consideration. To embed a chart from Excel: In Word, select the Insert tab. The Word file, or destination file, stores only the location of the source file, and it displays a representation of the linked data. Linked data is stored in the source file. When an object is linked, information can be updated if the source file is modified. If you embed the worksheet in the report, your report contains a static copy of the data. If you link the report to the worksheet, the data in the report can be updated whenever the source file is updated. You can insert objects this way from any program that supports the technology of linking and embedding objects (object linking and embedding, or OLE).įor example, a monthly status report may contain information that is separately maintained in an Excel worksheet. Now go to the Word document, place your cursor where you want the copied cells to go and click on Edit, Paste Special. If you place your cursor into your Word document and press Ctrl-V on the keyboard, you’ll notice that the cells you’ve selected appear perfectly in the Word document. Begin by highlighting the range of cells (A1 to D4) you want displayed in the document and copy it (Ctrl+C). To do this, you’ll open the Excel file with your data, highlight the cells that contain the data you want to bring into your document, and press Ctrl-C on the keyboard. You place either a link to the object or a copy of the object in the document. Caveat: Both the spreadsheet and the document must be in the same folder (subdivision).
#Insert into word document linked excel file 365 update
The main differences between linked objects and embedded objects are where the data is stored and how you update the data after you place it in the Word file.
Understand the differences between linked objects and embedded objects Unlike when you paste content (such as by pressing CTRL+V), when you insert it as a linked or embedded object, you can work with it in the original program.įor example, if you insert worksheet cells into the document as an Excel object, Microsoft Office Word runs Excel when you double-click the cells, and you can use Excel commands to work with the worksheet content. When you insert content as an object, you create a dynamic link between the content that you insert and the content that was created in another Microsoft Office program.