Pivot table issue

[keshri1]

How can i get pivot table data to different sheet. I am able to get in same sheet through getpivotdata function. But in another sheet it has some issue.

 

[keshri1]

Any one answer please.

 

[sandy666]

try double click on last value of Grand Total
eg.

or
copy your PivotTable to another sheet

 

[sandy666]

or maybe it will help a bit

How to Use Excel Pivot Table GetPivotData

In Excel pivot tables, stop GETPIVOTDATA formula from appearing when linking to pivot table. Fix formula to copy down correctly. How GetPivotData works

www.contextures.com