View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mistermonday Mistermonday is offline
external usenet poster
 
Posts: 2
Default 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