1. Home
  2. MS Office

Embed Data Sheet From Excel 2010 To Word Document

Excel 2010 includes a feature that helps users to embed and link different objects. OLE (Object Linking and Embedding) is a technique to insert data from one app in to another and update data accordingly. In this way, by using and linking the object of one application, we can make an updated copy.

To start with Object Linking and Embedding, launch Excel 2010, create or open an existing data sheet.

For illustration purpose, data sheet of student record is shown in the screenshot below.

Datasheet excel

We want to embed the specific datasheet portion in to Microsoft Word, to keep that portion updated with the above Excel datasheet, now copy the portion of the datasheet.

copy table 1

Open Word 2010, navigate to Home, click Paste drop down button and hit Paste Special.

paste special 1

Now click Paste link and select Excel Worksheet Object from the list. Click OK to continue.

paste special dialog 1

You will see selected datasheet portion is now pasted in to Word.

word pasted

Now open Excel, and change the data in the Marks table, compare it with the table  in Word, changes will be reflected in Word document immediately.

compare 1


  1. No longer works in 2010 between Excel and Word. Have had links from Excel to Word documents break 3 months running and had to rebuild each and every one ..each and every time. VERY frustrating.

  2. One note: Only cells that were original pasted into the Word doc are updated. Eg if you pasted 4 columns and 4 rows, but then added data into row 5, it won’t appear in the Word doc even after updating.

    Other than that, this worked perfectly – thanks!

  3. I want to embed an Excel worksheet in Word that will be used for a proposal. I need to be able to save the modified documents and still keep a master tied to the word document for future proposals. I don’t know how to link/save word and excel easily so they are always tied together, but the master documents can be used over and over again for new proposals.

    any ideas?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.