Extracting saved data from pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If you double-click on the grand total cell, it may extract all the
underlying data to a new worksheet.
 
Wonderful! Thanks a lot, Debra!

Debra Dalgleish said:
If you double-click on the grand total cell, it may extract all the
underlying data to a new worksheet.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

View Pivot Table Source data as a Data Table 6
Pivot Table - Changes 5
Pivot table filter list - listing irrelevant subcategorys 1
How do I add extra data to a pivot table? 3
How do I save Pivot Table Data 4
Adding to an existing Pivot Table 7
Issue with pivot table 1
Pivot tables - memory issues - please help 2

Back
Top