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 wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Marcus Langell]

Wonderful! Thanks a lot, Debra!

"Debra Dalgleish" wrote:

> If you double-click on the grand total cell, it may extract all the
> underlying data to a new worksheet.
>
> Marcus Langell wrote:
> > 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
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>