Excel for Mac PivotTable Fields Missing in a Data Model Workbook
Question details
The user needs to understand why PivotTable fields are unavailable after an Excel workbook is moved from Windows to Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- Mac
- Scenario
- A workbook containing a PivotTable created in Excel for Windows is opened on a Mac.
- Observed behavior
- The PivotTable does not expose expected fields, especially when its source relies on the Excel Data Model or Power Pivot.
Check whether the PivotTable was built from a standard worksheet table or from the workbook Data Model. In Excel for Windows, select the PivotTable and review its source and connections before moving the file to Mac.
Maintain Data Model and Power Pivot workbooks in Excel for Windows
Use this option when the PivotTable depends on the Data Model, Power Pivot relationships, or measures created in Excel for Windows.
Excel for Mac has limited support for Data Model and Power Pivot functionality depending on the Excel version. A PivotTable that relies on those features may open without the field list or without access to the underlying model objects.
Open the original .xlsx workbook in a supported desktop version of Excel for Windows.
Click inside the PivotTable, open the PivotTable Analyze tab, and select Change Data Source or Manage Data Model to confirm whether the report uses the Data Model.
Use Power Pivot or Data > Manage Data Model in Excel for Windows to maintain relationships, measures, calculated columns, and PivotTable fields.
Run Windows in a virtual machine on the Mac, then open the workbook in Excel for Windows to work with the Data Model-based PivotTable.
Rebuild the report as a standard PivotTable for Mac compatibility
Use this option when Mac users need to filter, refresh, and manage PivotTable fields without relying on Power Pivot features.
Use WPS Office for compatible spreadsheet workbooks and standard PivotTables
If you need a free, lightweight office suite for everyday spreadsheet work, WPS Office provides a familiar interface and smooth migration for compatible Excel files. It is well suited to opening, editing, and sharing standard .xlsx workbooks, while specialized Microsoft Data Model and Power Pivot workflows should remain in supported Windows Excel.
Frequently Asked Questions
Why are PivotTable fields missing only when I open the workbook on my Mac?
The PivotTable may use the Excel Data Model, Power Pivot relationships, or measures created in Excel for Windows. Excel for Mac may not expose or fully support those model-based fields.
How can I tell whether my PivotTable uses the Data Model?
Open the workbook in Excel for Windows, click the PivotTable, and use PivotTable Analyze > Change Data Source. You can also check Data > Manage Data Model or the Power Pivot tab for model tables, relationships, and measures.
Can Excel for Mac edit Power Pivot measures and relationships?
Support is limited and varies by Excel for Mac version. For reliable editing of Power Pivot measures, calculated columns, and Data Model relationships, use Excel for Windows.
Will saving the workbook as .xlsx make the missing fields appear on Mac?
No. The .xlsx format preserves the workbook, but it does not remove the feature limitation. The PivotTable must be rebuilt from a standard worksheet table if Mac-compatible field editing is required.
What is the best PivotTable format for Windows and Mac users?
Create a standard PivotTable from a single Excel table or worksheet range, and do not select the option to add the source data to the Data Model. This setup generally has better cross-platform compatibility.
