ExcelBanter - Extracting saved data from pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Extracting saved data from pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/75859-extracting-saved-data-pivot-table.html)

Marcus Langell

Extracting saved data from pivot table

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

Extracting saved data from pivot table

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

Extracting saved data from pivot table

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

All times are GMT +1. The time now is 09:44 PM.