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.
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.
Open Word 2010, navigate to Home, click Paste drop down button and hit Paste Special.
Now click Paste link and select Excel Worksheet Object from the list. Click OK to continue.
You will see selected datasheet portion is now pasted in to Word.
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.