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.

"Mistermonday" wrote:

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mistermonday" wrote in message
...
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.

"Mistermonday" wrote:

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