Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Link OfficeConnect Tables in Slides

Link OfficeConnect Tables in Slides

Link an table to an for PowerPoint presentation to:
  • Easily update the data originating in your online instance.
  • Format the data in a table in for Excel.
  • Link to online data in a board or executive presentation in for PowerPoint.
The process for linking a table from for Excel to a slide in for PowerPoint consists of two major steps,:
  1. Define the named range of cells that includes the table you want to link.
  2. Copy and link that table using its named range into your PowerPoint slide.

Link Tables to PowerPoint Slides

After you've created a named range for the table in for Excel, you're ready to link the table in for PowerPoint.
To link an for Excel table in a PowerPoint slide:
  1. In 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.
  2. Right-click in the named range, and then select
    Copy
    .
  3. In for PowerPoint, open the presentation and slide where you want to link the table.
  4. On the
    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 for Excel.
  5. Adjust the position and size of the table on the slide.
  6. Save your presentation. Open for PowerPoint and then open the file when you want to work with the table.
    Whenever the linked table is updated from your instance or from other changes you make in for Excel, you can easily update the table in your PowerPoint slide. On the
    tab in PowerPoint click
    Refresh All
    from the Linking group.