Edit a linked or embedded object

Microsoft Office Excel 2003

  1. On the Edit menu, click Links.
  2. In the Source file list, click the source for the linked object, and then click Open Source.
  3. Make the changes you want to the linked object.
  4. In the source program, click Exit on the File menu.

ShowEdit an embedded object in the source program

  1. Double-click the embedded object 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.

    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 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.