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

Advertisement
  • Pingback: Auto Fill In Excel 2010 and Word 2010 (RAND Function)

  • Pingback: Insert Excel Spreadsheet In Word 2010 Document

  • David

    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?

  • SusanPViray

    Thanks for the help.

  • exceller

    can i make it so a long table breaks over 2 pages?

  • fkhyber

    Thank you. it sure did help me

  • Shevek

    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!