Cut and Paste Data in a Pivot Table

[Moz]

Is there a way to cut and paste data from a pivot table to a new worksheet.
When I try to do this the cut and paste options are not available?

 

[Frank Kabel]

Hi
AFAIK this is not possible. But why do you want to 'cut' anyway?

 

[Moz]

Because I haven't yet learned how to assimilate multiple grand totals from
multiple pivot tables. I use a pivot table to grab daily results of our
Parts inventory. I have had remarkable improvement and wanted to give a snap
shot of the improvement by Grand Totals over a 20 day period.