Excel 2007 pivot table source table
In previous versions of Excel you could right click on a pivot table, select
Pivot Table Wizard, then click the back arrow button to check the source data table, worksheet, or file, and change the range. How to do this in Excel 2007? |
Excel 2007 pivot table source table
I notice that if you right click in the pivot data and select Show Details,
it inserts a new worksheet showing the source data. However since you're not viewing the source worksheet, you have no assurance that all rows have been included (if you've added some to the source sheet) and there's no indication of which worksheet it's working from. "sb" wrote: In previous versions of Excel you could right click on a pivot table, select Pivot Table Wizard, then click the back arrow button to check the source data table, worksheet, or file, and change the range. How to do this in Excel 2007? |
All times are GMT +1. The time now is 06:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com