- May 14, 2009
- Locating and Inserting Clip Art
- Inserting a Picture
- Adding a Quick Style to a Picture
- Applying a Shape to a Picture
- Applying Picture Effects
- Applying a Border to a Picture
- Modifying Picture Brightness and Contrast
- Recoloring a Picture
- Modifying Picture Size
- Cropping and Rotating a Picture
- Creating WordArt Text
- Formatting WordArt Text
- Modifying WordArt Text Position
- Creating SmartArt Graphics
- Formatting a SmartArt Graphic
- Modifying a SmartArt Graphic
- Creating an Organization Chart
- Modifying an Organization Chart
- Inserting and Creating a Chart
- Changing a Chart Type
- Changing a Chart Layout Style
- Changing Chart Titles
- Changing Chart Labels
- Editing Chart Data
- Sharing Information Between Programs
- Linking and Embedding Objects
- Flagging Documents for Follow Up
Sharing Information Between Programs
Office can convert data or text from one format to another using a technology known as object linking and embedding (OLE). OLE allows you to move text or data between programs in much the same way as you move them within a program. The familiar cut and paste or drag and drop methods work between programs and documents just as they do within a document. In addition, all Office programs have special ways to move information from one program to another, including importing, exporting, embedding, linking, and hyperlinking.
Importing and Exporting
Importing and exporting information are two sides of the same coin. Importing copies a file created with the same or another program into your open file. The information becomes part of your open file, just as if you created it in that format. Some formatting and program-specific information such as formulas may be lost. Exporting converts a copy of your open file into the file type of another program. In other words, importing brings information into your open document, while exporting moves information from your open document into another program file.
Embedding inserts a copy of a file created in one program into a file created in another program. Unlike imported files, you can edit the information in embedded files with the same commands and toolbar buttons used to create the original file. The original file is called the source file, while the file in which it is embedded is called the destination file. Any changes you make to an embedded object appear only in the destination file; the source file remains unchanged.
For example, if you place an Excel chart into a PowerPoint presentation, Excel is the source program, and PowerPoint is the destination program. The chart is the source file; the document is the destination file.
Linking displays information from one file (the source file) in a file created in another program (the destination file). You can view and edit the linked object from either the source file or the destination file. The changes are stored in the source file but also appear in the destination file. As you work, Office updates the linked object to ensure you always have the most current information. Office keeps track of all the drive, folder, and file name information for a source file. However, if you move or rename the source file, the link between files will break.
Once the link is broken, the information in the destination file becomes embedded rather than linked. In other words, changes to one copy of the file will no longer affect the other.
Embedding and Linking
The program that created the original object
The file that contains the original object
The program that created the document into which you are inserting the object
The file into which you are inserting the object