Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Edit a linked or embedded object
 

ShowEdit a linked object in the source program

  1. On the Edit menu, click Links.
  2. In the Source file list, click the source for the linked object (linked object: An object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.), and then click Open Source.
  3. Make the changes you want to the linked object.
  4. In the source program (source program: The program used to create a linked object or embedded object. To edit the object, you must have the source program installed on your computer.), click Exit on the File menu.

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.

advertisement