Chapter 11. WORKING WITH EXTERNAL DATA

Paste Link into Word

You can place Excel data in other programs. In Word, for example, you can use Excel worksheet data to present quarterly reports or other financial documents. In PowerPoint, you can use Excel worksheet data to illustrate your presentations.

You can add Excel worksheet data to Word or PowerPoint by using the Copy and Paste commands. The Copy command copies the Excel data. The Paste command places the copy in another document. When you copy and paste, if you make changes to the original Excel document, you must go into the Word or PowerPoint document and update it as well.

You can also place Excel data in Word or PowerPoint by using a paste link. When you use a paste link, if you alter Excel ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.