Sharing Data

1. Sharing Data OLE

2. Integration • Integration is the sharing of data between MS office applications • Paste • Link • Embed • Clipboard • Anything copied or cut is placed on the “clipboard” • Can be pasted into another application Prof. Leighton

3. Object Linking and Embedding • Compound document contains objects from other applications • An object is a package of data or information • OLE is the technology that lets you share info across applications Prof. Leighton

4. From Where to Where • The source application contains the original material • Also called the server application • The destination application receives the data • Also called the client application Prof. Leighton

5. Differences between Embedding and Linking • The embedded object is stored in the compound document • Can edit the embedded object within the destination application • The embedded object is not used by any other client applications • Embedding creates a large destination file • The embedded file is included in the destination file Prof. Leighton

6. The embedded chart is in edit mode and we are in Excel within the Word document Prof. Leighton

7. Differences between Embedding and Linking? • A linked object is stored in its own file • There is a pointer in the destination file to the source file • When you link materials, any changes that you make in the source file are also made in the destination file • The linking procedure saves disk space • The source file is saved outside of the destination file • The source file can have many client files Prof. Leighton

8. When Do I Use… • Use embedding if you need the actual object • Plan on editing the compound document on a different computer • Use linking if the source file is likely to be updated frequently • The compound document needs the latest information • Use linking when the source is used in many destination files Prof. Leighton