View Pivot Table Source Data
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
|