Pivot Table Issues

Create Multiple PivotTables from One Source in Excel for Mac

Steven ParkerSteven Parker Nov 14, 2026 870 views

Question details

The user wants to create a second PivotTable from the same data source in Excel for Mac.

Create Multiple PivotTables from One 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the source data

Click a cell in the original data table or select the source range, including its column headers.

2
Open the PivotTable dialog

On the Insert tab, click PivotTable and check that the table or range shown is the intended source.

3
Choose a separate location

Select New Worksheet in the PivotTable dialog, then confirm to create the second PivotTable.

4
Build the report

Use the PivotTable field list to add fields to Rows, Columns, Values, or Filters as needed.

Create the second PivotTable on a new worksheet
If the error remains: Record the exact message and the step at which it appears. Compare your steps with Microsoft's instructions for creating a PivotTable in Excel for Mac.
Free Microsoft Office alternative

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.

Create and explore PivotTable reports in WPS SpreadsheetsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceMove existing workbooks to a lightweight office suite
microsoft office alternative - wps office

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.