MS Excel: Change data source for a pivot table in Excel 2011 for Mac
Also learn how to change the data source for a pivot table in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.
Question: In Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?
Answer:Click somewhere in the pivot table and the PivotTable tab should appear in the toolbar at the top of the screen. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu.
When the Change PivotTable Data Source window appears, change the Location value to reflect the new data source for your pivot table. Click on the OK button.
Now when you return to your pivot table, it should display information from the new data source.
