Link an OfficeConnect table to an OfficeConnect for PowerPoint presentation to:
- Easily update the data originating in your online instance.
- Format the data in a table in OfficeConnect for Excel.
- Link to online data in a board or executive presentation in OfficeConnect for PowerPoint.
The process for linking a table from OfficeConnect for Excel to a slide in OfficeConnect for PowerPoint consists of two major steps,:
- Define the named range of cells that includes the table you want to link.
- Copy and link that table using its named range into your PowerPoint slide.
See Use Named Ranges.
Link OfficeConnect Tables to PowerPoint Slides
After you’ve created a named range for the table in OfficeConnect for Excel, you’re ready to link the table in OfficeConnect for PowerPoint.
To link an OfficeConnect for Excel table in a PowerPoint slide:
In OfficeConnect for Excel, click the arrow in the Name Box and select the named range in the drop-down.
The named range appears and is selected in the grid.
Right-click in the named range, and then select Copy.
In OfficeConnect for PowerPoint, open the presentation and slide where you want to link the table.
On the OfficeConnect tab, in the Linking group, select Paste Table.
Use this command instead of the Office Paste command. The Paste Table command ensures the data is linked and can be quickly updated.
The table is inserted into the slide with a link to OfficeConnect for Excel.
Adjust the position and size of the table on the slide.
Save your presentation. Open OfficeConnect for PowerPoint and then open the file when you want to work with the table.
Whenever the linked table is updated from your Adaptive Planning instance or from other changes you make in OfficeConnect for Excel, you can easily update the table in your PowerPoint slide. On the OfficeConnect tab in PowerPoint click Refresh All from the Linking group.