Pivot Table Data Source

[Poogermum]

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 basis  of a pivot table comes from. If I am looking a

[#2]

@Poogermum On the Pivot Table Analyse ribbon, look for the "Change Data Source" button. Click and it will show you the current source.