View Pivot Table Source Data

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

Guest

I rec'd an Excel workbook that only contains a Pivot Table. The Data Sheet
used to create it was not included but all of the data is embedded - the
field list is present and the pivot table can be modified. How can I view
the orig block of data in its original tabular format?
Thanks and Regards,
MM
 
Never mind, I found it. An older copy of a workbook with the same name which
has an earlier data sheet was acting as the source. Once I removed it I
could see that there was no way to access data which did not exist.
 
Also, you could format the pivot table to show row and column totals, then
double click on the Grand Total cell in the bottom right. This drills down,
creating a new worksheet that includes all records which contribute to the
grand total.

- Jon
 
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

pivot table data 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table - Changes 5
View Pivot Table Source data as a Data Table 6
Pivot tables - memory issues - please help 2
Pivot tables - Editing the data source shared by multiple pivot ta 1
Easy way to change Pivot table source files? 5
Pivot Table Data Source 1

Back
Top