Chapter 15 Linking
THOMSON REUTERS SPREADSHEET LINK - USER GUIDE
PAGE 163 OF 235
Linking provides a connection between Microsoft Excel and PowerPoint or Word in which PowerPoint or Word can
display data, tables, charts, or other content that you create in Excel.
You can export from Excel to PowerPoint or Word and then manage your links and refresh the content from either
Excel or the target application.
You must save your Excel spreadsheet, Word document, and/or PowerPoint presentation before you can use
Import and Export Content (Linking)
Import into PowerPoint from Excel (Linking)
While you are working in a saved PowerPoint presentation or Word document, you can import content from an
Excel workbook. You can link multiple individual, non-contiguous cells from Excel to PowerPoint or Word into a
single text box. You can also import charts, tables, and text from Excel into a PowerPoint slide or onto a
placeholder or the cursor location of a Word document.
Before you import, you must decide whether you want to import part of the contents of an Excel worksheet, such as
a selection of cells or an object on a worksheet, such as a graph or chart, onto the PowerPoint slide or Word
document and whether you want to be able to edit the content in the target application.
If you want to import an object from an Excel worksheet, you can perform a quick import of a that object to
PowerPoint (see "Perform a Quick Import of an Object from Excel into PowerPoint (Linking)" on page 163) or Word
(see "Perform a Quick Import of an Object from Excel into Word (Linking)" on page 165) using Import Selection,
and the content imports as you set your default in Options (see "Set Default Link Options (Linking)" on page 168).
Alternatively, you can import objects from an Excel worksheet while retaining the ability to update the content
either in the target application or in Excel. To do so, see Import a Chart, Text, Graph, or Named Range into
PowerPoint from Excel (see "Import a Chart, Text, Graph, or Named Range into PowerPoint from Excel (Linking)"
on page 162) or Import a Chart, Text, Graph, or Named Range into Word from Excel (see "Import a Chart, Text,
Graph, or Named Range into Word from Excel (Linking)" on page 164), and select to import the selection as
Import a Chart, Text, Graph, or Named Range into PowerPoint from Excel (Linking)
You can import charts, tables, numeric values, and text from Excel into a PowerPoint slide. You can import objects
or select cells from Excel.
To import objects from a worksheet to PowerPoint from Excel
Open the Excel worksheet that you want to import into PowerPoint.
Open the PowerPoint presentation and slide to which you want to import the Excel content.
To import to PowerPoint 2003, go to the Linking menu, point to Import, and click Import.
To import to PowerPoint 2007 or 2010, go to the Thomson Reuters Linking group on the Insert tab, click the
arrow below Import, and click Import.
In the Excel worksheet, name a range (see "Set Standardized Names (Linking)" on page 169).
In PowerPoint in the Import Excel Object dialog, select the spreadsheet from the Select a file drop-down.
If it is not in the drop-down, click Browse, and, in the Select File dialog, browse for the file, click Open, and
then select it from the drop-down.
Click the down arrow next to Link Options, and select link options (see "Link Options (Linking)" on page 167).
Click the arrow next to Select Objects, and select objects.