So if I use this method and then change anything in the original Excel file, it would be reflected in the Word data as well. This means that editing the source file will cause the changes to also get reflected in the target file and vice-versa, provided that both documents are open. You will get the most flexibility if you insert your Excel data into Word as a linked object.Ī linked object is different from an embedded object in that the embedded object is like a snapshot or copy of the original file, while a linked object maintains an active connection between both files.
Inserting an Excel File into Word as a Linked Object If you want even more flexibility, the next method may be helpful for you. This is because the object is basically just a copy of the original file. Similarly, any changes you make to the original Excel file will not get reflected in this object. It is important to note, however, that any changes you make to the object will not get reflected to the original Excel file. You can come out of edit mode when you click outside the object window. It will open the spreadsheet in an Excel interface (felt like pure magic when I first used it). If you want to edit the table, simply double-click inside the object. So you can apply formulas and work on it as a regular excel table.
Note: The inserted table is not a regular Word table. So you can go ahead and resize it as required. The size of the embedded object might not fit correctly to your Word doc’s margins. This will insert the copied cells into your Word doc. Under the Home tab, click on the dropdown of the Paste button (in the Clipboard group).Place your cursor where you want to insert the Excel table.To embed an Excel file into a Word file, follow the steps below: This means that you can open the embedded Excel file from Word itself and make changes in it. Moreover, you get to alter the embedded object using the original program.
This is made possible by the Windows OLE technology (Object Linking and Embedding).Įmbedding the object, rather than just pasting it, ensures that the object retains its original format. Inserting an Excel File into Word as an Embedded ObjectĪn alternative way to insert an Excel file into Word is by inserting it as an embedded object.Īn embedded object is an object that is created with one application and then embedded into a document that is created by another application.įor example when you embed an object or file created in Excel into a document created in Microsoft Word. If you want to take advantage of Excel formulas inside Word, then the next two methods might work better for you. So you cannot use Excel formulas in the table once it is pasted to Word