In Microsoft Excel, highlight the entire pivot table. Then “Right Click” on it and select the “Copy” option from the right-click menu.
Click on the “Paste” option under the clipboard icon in the “Home” tab. In the dropdown menu under the “Paste” option, click on the “Paste Special” option.
In the “Paste Special” dialog box, click on the “Microsoft Excel Worksheet Object” option. Then click on the “OK” button.
To do so, select the pivot table pasted on the slide. Then click on the “Animations” tab in the menu ribbon located at the top of the screen.
In the “Animation” group of the “Animations” tab, click on the down arrow which will expand the animation list available in PowerPoint. Click on the “OLE Action Verbs” option.
In the “Change OLE Action Verb” dialog box, click on the “Edit” tab at the bottom. Then all you have to do is click on the “OK” button.