Extracting saved data from pivot table

[Marcus Langell]

I have a pivot table with saved data. The original input data is no longer
present. Is there a way that I can extract the original data from the pivot
table?

 

[Debra Dalgleish]

If you double-click on the grand total cell, it may extract all the
underlying data to a new worksheet.

 

[Marcus Langell]

Wonderful! Thanks a lot, Debra!

If you double-click on the grand total cell, it may extract all the
underlying data to a new worksheet.