Change the source data for a PivotTable

To change the source data for a PivotTable in Excel — whether you’ve added more data or want to switch to a different range or table — here’s how to do it:

✅ Steps to Change the Source Data of a PivotTable

🔁 Method 1: Change to a New Range or Table

1. Click anywhere inside the PivotTable to activate it.
2. Go to the PivotTable Analyze tab (or Options tab in older versions).
3. Click Change Data Source (in the Data group).
4. In the Change PivotTable Data Source dialog:
   • Update the range or table name in the Table/Range box.
     • Example: Sheet1!$A$1:$D$100 → Sheet1!$A$1:$D$150
     • Or use a table name: SalesData
5. Click OK.

The PivotTable will now reflect the new source data.

🧠 Tip: Use a Table as a Data Source

• If your data is in a Table (created with Ctrl + T), the PivotTable will automatically expand as you add new rows — no need to change the source manually each time.

🔄 Method 2: Use a Different Worksheet or Workbook

• Follow the same steps above.
• In the Table/Range box, type or select a range from the other sheet or workbook.
• For external workbooks, ensure both are open and refer to the range like this:

  '[OtherWorkbook.xlsx]Sheet1'!$A$1:$D$100
  

🧹 Note: If fields are missing after changing the source…

• Click Refresh (PivotTable Analyze tab → Refresh).
• If field names changed, you may need to reconfigure the PivotTable layout using the Field List.