Create Multiple PivotTables from One Source in Excel for Mac
Question details
The user wants to create a second PivotTable from the same data source in Excel for Mac.

- Product
- Microsoft Excel 2016 for Mac
- Device & OS
- Mac
- Scenario
- A large data table needs to support multiple PivotTables in the same workbook.
- Observed behavior
- Excel reports that a PivotTable already exists from the source, and a suggested Windows keyboard shortcut does not work on Mac.
Check that the source data has a header in each column and identify the source range or table name. Note the exact error message and when it appears.
Create the second PivotTable on a new worksheet
Use Excel's Mac menus to create another PivotTable from the same source and give it a separate location.
Excel can create multiple PivotTables from one source table. The Windows Alt+P+D shortcut may not apply to Excel for Mac.
Click a cell in the original data table or select the source range, including its column headers.
On the Insert tab, click PivotTable and check that the table or range shown is the intended source.
Select New Worksheet in the PivotTable dialog, then confirm to create the second PivotTable.
Use the PivotTable field list to add fields to Rows, Columns, Values, or Filters as needed.

Test a simple source range
Use a small sample to determine whether the error also occurs outside the large source table.
Explore PivotTable Reports with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files and work with PivotTables in WPS Spreadsheets as you move between office suites. It does not fix the error in Microsoft Excel itself.

Frequently Asked Questions
Can two PivotTables use the same source data in Excel for Mac?
Yes. Select the source table or range and use Insert > PivotTable for each report. Choosing a new worksheet for the second report gives it a separate location.
Why doesn't Alt+P+D work in Excel for Mac?
Alt+P+D is a Windows shortcut and may not apply to Excel for Mac. Use Insert > PivotTable to create a report instead.
How can I check whether the large data table is related to the error?
Create a small sample range in a new workbook, then use Insert > PivotTable twice with that range. Compare the result and note exactly when any error appears.
What information should I provide if I need more help?
Provide the exact error message, the steps you used, and whether the same issue occurs with a simple range. If possible, share a test workbook without personal information.




