Object linking and embedding is one of the great recent innovations in personal computing. OLE lets you insert an object created in one program into a document created in another program. Terms that you'll find useful in understanding how you can share objects among documents include:
For example, if you place an Excel chart in your PowerPoint presentation, Excel is the source program and PowerPoint is the destination program. The chart is the source file; the presentation is the destination file. There are three ways to share information in Windows programs: pasting, embedding, and linking.
You can cut or copy an object from one document and then paste it into another using the Cut, Copy, and Paste buttons on the source and destination program toolbars .
When you embed an object, you place a copy of the object in the destination file, and when you activate the object, the tools from the source program become available in your presentation. For example, if you insert and then click an Excel chart in your PowerPoint presentation, the Excel menus and toolbars replace the PowerPoint menus and toolbars, so you can edit the chart if necessary. With embedding, any changes you make to the chart in the presentation do not affect the original file.
When you link an object, you insert a representation of the object itself into the destination file. The tools of the source program are available, and when you use them to edit the object you've inserted, you are actually editing the source file. Moreover, any changes you make to the source file are reflected in the destination file.