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