Edit a linked or embedded object

ShowEdit a linked object in the source program

ShowEdit an embedded object in the source program

  1. Double-click the embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.) to open it.
  2. Make the changes you want to the object.
  3. If you are editing the object in place in the open program, click anywhere outside the object to return to the destination file (destination file: The file that a linked or embedded object is inserted into. The source file contains the information that is used to create the object. When you change information in a destination file, the information is not updated in the source file.).

If you edit the embedded object in the source program in a separate window, click Exit on the File menu to return to the destination file.

 Note   Double-clicking certain embedded objects, such as video and sound clips, plays the object instead of opening a program. To edit one of these embedded objects, click the object, point to object type Object on the Edit menu, and then click Edit.

ShowEdit an embedded object in a program other than the source program

  1. Select the embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.) you want to edit.
  2. On the Edit menu, point to object name Object (for example, Document Object), and then click Convert.
  3. To convert the embedded object to the type you specify in the list, click Convert to.

To open the embedded object as the type you specify in the list without changing the embedded object type, click Activate.

Note To select an object by using the keyboard, do the following:

  1. Press CTRL+G to display the Go To dialog box.
  2. Click Special, then select Objects, and click OK.
  3. Press tab until the object you want is selected.
  4. Press SHIFT+F10.
  5. Point to Object or Chart Object, then click Edit.
 
 
Applies to:
Excel 2003