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?