

You receive an Excel workbook with a PivotTable and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table? Unfortunately the function for seeing and changing the data source of a Pivot Table is a little bit hidden. Luckily, once you know where to find the button, it’s quite to see and change the source of the Pivot Table simple.
For seeing or changing the source data of a Pivot Table you have to click on the ‘Change Data Source’ button on the Analyze ribbon. Therefore (and if you haven’t found it yet) follow these steps (the numbers in the list below are corresponding to the picture):
Steps for seeing and changing the data source of a PivotTable
For large data sets (>500,000 rows) refreshing the data might take some time.
If you are interested: We got a lot more articles about PivotTables in Excel. Here is some selection:
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Subscribe to our popular Excel newsletter! You get all this:
Your welcome gift: Our big 45 pages keyboard shortcuts package.
Subscribe now! In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Please use this download link to download the Currency Converter Excel add-in!
Please use this download link to download the comment extraction example: http://bit.ly/Extract_Comment_Example