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
 
Back
Top