This chapter is from the book

This chapter is from the book

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

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

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

Term

Definition

Source program

The program that created the original object

Source file

The file that contains the original object

Destination program

The program that created the document into which you are inserting the object