The data source for a pivot table can be identified by:
- Selecting a cell (any cell) in the pivot table of interest.
- Choosing 'Ganti Sumber Data' from the 'Opsi' tab of the 'Alat PivotTable' part of the ribbon, then selecting 'Gant Sumber Data...'.
- Excel will move to the data range that is the source of the pivot table, and open up a 'Ubah Sumber Data PivotTable' dialog box, which will be filled with the pivot table's current data source.
- Click 'Batal' once the details have been noted (we don't actually want to change the data source).