Share via

Is it possible to display an Excel pivot table in Powerpoint?

Anonymous
2013-09-25T13:16:18+00:00

I don't want to create a lot of slides, I just want one slide with an embedded Excel pivot table.  Is this possible?

Microsoft 365 and Office | PowerPoint | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. triptotokyo-5840 36,681 Reputation points Volunteer Moderator
    2013-09-25T14:43:29+00:00

    You can certainly do the following:-

    1. If you wish to edit the Pivot Table within PowerPoint make sure that in the source EXCEL Workbook you set up the Pivot Table in a separate Worksheet from the underlying data.

    2. Go into EXCEL and highlight the required Pivot Table then:-

    CTRL-C

     - to copy it.

    3. Go into PowerPoint and click at the place where you wish to embed the Pivot Table just copied then:-

    Home tab

    Clipboard group

    Click on the drop down arrow beneath:-

    Paste

     - then click on:-

    Paste Special . . .

    The:-

    Paste Special

     - window should open.

    4. In the:-

    Paste Special

     - window in the field called:-

    As:

     - make sure that:-

    Microsoft Office Excel Worksheet Object

     - is selected (if it's not already selected) then click on:-

    OK

    I reckon that the above gives you what you want.

    1 person found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-09-25T15:46:29+00:00

    Thanks for all your help.  You are extremely generous with your knowledge.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-09-25T15:23:09+00:00

    With an embedded object can you edit the pivot table in "slide show"?  I want to be able to change what the pivot table shows while in "slide show" without exiting the slide show, editing the pivot table, refreshing data, and re-entering slide show.

     

    . . . that's not what you asked for in your first posting! <-which is why I clarified

     

    but what you have is a picture of a pivot table not a pivot table.

     

    No it isn't: it's a fully embedded Pivot Table in PowerPoint that you can edit in PowerPoint independently of the source data in EXCEL. <-But you can't edit it in slide view.  You have to exit slide view, edit the pivot table, re-enter slide view.  As long as you're in slide view, it is only a picture of a pivot table.

     

     Thanks for your help.

    1 person found this answer helpful.
    0 comments
  3. triptotokyo-5840 36,681 Reputation points Volunteer Moderator
    2013-09-25T15:10:35+00:00

    With an embedded object can you edit the pivot table in "slide show"?  I want to be able to change what the pivot table shows while in "slide show" without exiting the slide show, editing the pivot table, refreshing data, and re-entering slide show.

    . . . that's not what you asked for in your first posting!

    but what you have is a picture of a pivot table not a pivot table.

    No it isn't: it's a fully embedded Pivot Table in PowerPoint that you can edit in PowerPoint independently of the source data in EXCEL.

    0 comments
  4. Anonymous
    2013-09-25T15:03:43+00:00

    Let me clarify...

    With an embedded object can you edit the pivot table in "slide show"?  I want to be able to change what the pivot table shows while in "slide show" without exiting the slide show, editting the pivot table, refreshing data, and re-entering slide show.  I can certainly put in a pivot table as you describe, but what you have is a picture of a pivot table not a pivot table.

    0 comments