Excel 2010 Bible

Part IV: Using Advanced Excel Features

622

FIGURE 29.5

Use Word’s Links dialog box to modify or break links.

Embedding Objects in a Worksheet

Using Object Linking and Embedding (OLE), you can also embed an object to share information

between Windows applications. This technique enables you to insert an object from another pro-

gram and use that program’s editing tools to manipulate it. The OLE objects can be such items as

l Text documents from other products, such as word processors

l (^) Drawings or pictures from other products
l Information from special OLE server applications, such as Microsoft Equation
l (^) Sound files
l Video or animation files
Many (but certainly not all) Windows applications support OLE. Embedding is often used for a
document that you will distribute to others. It can eliminate the need to send multiple document
files and help avoid broken link problems.
To embed an object into an Excel workbook, choose Insert ➪ Text ➪ Object, which displays the
Object dialog box. This dialog box has two tabs: one for creating a new object and one for creating
an object from an existing file.