This Excel tutorial explains how to change the data source for a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions).

• Create Pivot Table In Excel For Mac 2016
• Spreadsheets To Practice Pivot Tables
• Refresh Pivot Table In Excel Macro
• What Is A Pivot Table In Excel
• Pivot Tables In Excel Format As Date

See solution in other versions of Excel:

Question: In Microsoft 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?

Create Pivot Table In Excel For Mac 2016

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.

• Learn the Excel keyboard shortcuts (MAC and PC) to use Pivot Tables. Includes a full description. This App is not compatible with Smartphones and Tablets. Please try this in desktop or laptop. Excel Pivot Table Shortcuts. Open Pivot Table Wizard.
• WATCH PART 2: Download file used in the video: In this video.

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.

Spreadsheets To Practice Pivot Tables

Refresh Pivot Table In Excel Macro

What Is A Pivot Table In Excel

By Geetesh Bajaj, James Gordon. In Excel 2011 for mac, a PivotTable is a special kind of table that summarizes data from a table, data range, or database external to the workbook.If you’re PivotTable aficionado, you will be in seventh heaven with the new PivotTable capabilities in Office 2011 for Mac. By default, a Pivot Table will count all records in a data set. To show a unique or distinct count in a pivot table, you must add data to the object model when the pivot table is created. In the example shown, the pivot table displays how many unique colors are sold in each state. The pivot table shown is based on two fields: State.

Pivot Tables In Excel Format As Date

Now when you return to your pivot table, it should display information from the new data source.