Excel 2000 in a Nutshell

Name

Insert → Object

Synopsis

Excel allows you to insert an OLE (Object Linking and Embedding) object directly into your worksheet. This means that you are placing an object from another windows program into your worksheet. When you select the object, Excel provides you the ability to use the other programs editing tools to modify it. For example, Figure 6-23 shows a sample of a Microsoft Map object that has been embedded in a worksheet. When the object is added, the Microsoft Map toolbars display providing the ability to modify the object directly within Excel.

Figure 6-23. Microsoft Map Object with Editing Tools displayed within Excel

When you select Insert → Object, the Object dialog displays as shown in Figure 6-24. There are two different tabs that allow you to either create a new OLE object by selecting one of the object types listed on the Create New tab, or insert an existing object by locating the desired object on the Create from File tab.

Figure 6-24. Object Dialog

Only the programs on your machine that support OLE objects will be listed on the Create New tab. When you select one of the programs on the Create New tab, the program environment opens within your worksheet so you can create your OLE image. For example, in Figure 6-23 a map of Mexico was inserted directly into the ...