View original (French)

Insert a live-updating table in PowerPoint

doolly1994 Posted messages 3 Status Member -  
m@rina Posted messages 27617 Registration date   Status Moderator Last intervention   -
Hello, I need to create a stats report in PowerPoint, and I would like to insert an updatable "pivot table" created in Excel into my PowerPoint.
I can't find how to do it; when I insert a spreadsheet and paste my table into it, if I want to update it (under: DATA; Refresh all), the values become incorrect.

Is it possible to do what I want? If so, how?

Thank you in advance to everyone!!

2 answers

  1.
    m@rina Posted messages 27617 Registration date   Status Moderator Last intervention   11 563
     
    Hello,

    This is something that is very commonly done, and I don't see how the result could be wrong after updating.
    Moreover, by default, the update is automatic and therefore, in principle, unnecessary.

    Did you paste the pivot table with a link? => Paste special => Paste with link.

    Pasting can be done either by linking or by embedding. If you choose embedding, there is no link to your original Excel file. It will simply be a straightforward copy of your entire original file, but it will become an integral part of the PowerPoint presentation.

    m@rina

    --
    How it works is a public forum. I do not respond to questions asked in private messages.
    0