Embedding and Linking from the Clipboard

When you copy data to the Clipboard, the source application typically posts the data to the Clipboard in a variety of formats. When you use the Paste Special command in Excel (or another application, if you’re not pasting into Excel), the Paste Special dialog box lists all the available formats that the receiving application knows how to use.

For example, suppose you copy a Microsoft Office PowerPoint 2007 slide. PowerPoint posts the slide to the Clipboard in more than a dozen formats. (If you’re using Windows XP, you can see the available formats by opening the Clipbook Viewer application, Clipbrd.exe.) If you right-click a cell on your Excel worksheet and click the Paste Special command, the Paste Special ...

Get Microsoft® Office Excel® 2007 Inside Out 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.