Share this Page URL

Chapter 24. Integrating Excel with Other... > Managing Objects and Links - Pg. 622

Integrating Excel with Other Office Applications 622 Figure 24.5. The Paste Special dialog box enables you select the data format you want to use when pasting from the Windows Clipboard. 6. 7. 8. Select the Paste Link button if you want to keep a link to the original file. Select Paste if you want to copy the data without linking to the original file. Check the Display as Icon check box if you want to see an icon representing the object instead of seeing the actual data. Click OK to complete the Paste Special command. Managing Objects and Links Once you have embedded an object in a workbook, you may need to make changes to the object. You can change the position and appearance of the object in the Excel workbook or work with the data from the server application Formatting and Positioning Objects If you have placed an object in Excel, you have several options for changing the appearance, lo- cation, and size of the object. It is important to understand, however, that Excel does not have complete control over the appearance of the object. When you place an object, the server application is responsible for defining the general appearance of the object. For example, a Word object looks like a Word document and a PowerPoint object looks like a PowerPoint slide. If you want to change the appearance of some internal aspect of the object, such as its font, color, or the actual contents of the object, you must first activate the server application. You'll learn to activate an object in the section, "Activating an Embedded Object." You can change some aspects of the object's appearance by using Excel, however. Changing the Size and Position of an Object with the Mouse You can easily change the size and position of an object by using the mouse. 1. 2. Click the object to select it. Figure 24.6 shows an object in an Excel workbook that has been selected. To move the object, click the object and drag it to a new position.