Excel 2010 Bible

615

CHAPTER

Sharing Data with

Other Office

Applications

IN THIS CHAPTER

Understanding data sharing

Pasting and linking data

Embedding objects in a

worksheet

Embedding a workbook in a

Word document

T

he applications in Microsoft Office are designed to work together.

These programs have a common look and feel, and sharing data

among these applications is usually quite easy.

Excel can import and export a variety of different file types. Besides sharing

data using files, you can also transfer data to and from other open Windows

applications in several other ways:

l (^) Copy and paste, using either the Windows Clipboard or the Office
Clipboard. Copying and pasting information creates a static copy of
the data.
l Create a link so that subsequent changes in the source data will be
reflected in the destination document.
l Embed an entire object from one application into another applica-
tion’s document.
This chapter explores some ways in which you can make use of other appli-
cations while working with Excel, as well as some ways in which you can use
Excel while working with other applications.

Copying and Pasting

Copying information from one Windows application to another is quite easy.

The application that contains the information that you’re copying is the

source application, and the application to which you’re copying the informa-

tion is the destination application.