View Pivot Table Source Data
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 |
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 |
View Pivot Table Source Data
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 |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com