Microsoft Excel 2007

 

Object Linking and Embedding

 

Object Linking and Embedding (or OLE for short) is a technique used to insert data from one programme into another. We'll create a simple spreadsheet to illustrate the process, and place it in to Word 2007. When the Excel spreadsheet is updated, you'll see the Word version update itself as well.

If you don't want the data to update in Word, for example, it's called Embedding; if you do want the data to update, it's called Linking. We're going to do Linking. For this exercise, you need Word 2007 as well as Excel 2007.

First, create the simple spreadsheet below, and enter the formula shown in cell E3:

When you enter a number in cell E1, the answer is placed in cell E3 (don't do this yet).

With your spreadsheet created, highlight the cells A1 to E3. Click on the Home menu in Excel 2007. On the Clipboard panel, click on Copy.

Now switch to Word 2007. On the Home menu in Word 2007, locate the Clipboard panel, and the Paste item:

Click on Paste. From the Paste menu, select Paste Special:

When you click on Paste Special, you'll see the following dialogue box appear:

Select Microsoft Office Excel Worksheet Object from the dialogue box. On the left hand side, select Paste Link. Click OK.

When you click OK, Word 2007 will insert the spreadsheet from Excel:

It's even retained the cell formatting!

To check that it really does update in Word 2007, switch back to Excel. Click inside Cell E1 and enter the number 7. Press the Enter key on your keyboard, and you should have the same answer as in the image below:

Now switch back to Word 2007, and you should see that it too has the same answer:

Word 2007 has successfully linked the data from Excel 2007! If you don't want the updates, you would choose Paste from the Paste Special dialogue box instead of Paste Link.

You can link or embed things like Charts or Pivot Tables into Word 2007, though, and it can come in really useful.

 

In the next part, you'll see how to reference formulas and data on other worksheets.

 

< -- Hyperlinks | Reference other Worksheets -->

<--Back to the Excel 2007 Contents Page

View all our Home Study Computer Courses