O'Reilly logo

Excel® 2007 Bible by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 29. Sharing Data with Other Applications

<feature><title>In This Chapter</title> </feature>

The 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. This chapter explores some ways in which you can make use of other applications while working with Excel, as well as some ways in which you can use Excel while working with other applications.

Understanding Data Sharing

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:

  • Copy and paste, using either the Windows Clipboard or the Office Clipboard. Copying and pasting information creates a static copy of the data.

  • Create a link so that changes in the source data are reflected in the destination document.

  • Embed an entire object from one application into another application’s document.

This chapter discusses these techniques and shows you how to use them.

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 called the source application, and the application to which you’re copying the information is called the destination application.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required