How to Change Pivot Table Data Source

After creating a pivot table, you need to change the data source if you have made changes to the data. Please see below for details:

Step 1: Click any cell in the Pivot Table;

Step 2: Click the "Analyze" tab from the Ribbon (Note: please click "Options" if Excel 2010), then click "Change Data Source" command in the "Data" section;

Step 3: This will guide you back to the data source and you need to select the data range to include all data;

Step 4: The pivot table will also change based on the new data range.

Leave a Reply