Forum Discussion
Pivot Table Data Source
Hi a very simple and possibly stupid question.... How do you find the data source of a pivot table??? if I am looking at a very large spreadsheet it might be not apparent where the data which is basi...
Poogermum On the Pivot Table Analyse ribbon, look for the "Change Data Source" button. Click and it will show you the current source.