Fix Windows-Created PivotTables That Do Not Work in Excel for Mac
Question details
Restore access to PivotTables created in Windows that have disabled controls in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A user opens a Windows-created workbook on a Mac and tries to use its existing PivotTables.
- Observed behavior
- Existing PivotTable controls are disabled and Excel reports an unsupported external data source, while newly created PivotTables work normally.
Check whether the affected PivotTables use an external connection or a Windows data model, and have access to the source data or a Windows computer for inspection if possible. Menu names may vary by Excel and macOS version.
Update Excel and macOS, then test the PivotTable
Use current supported software to rule out compatibility issues addressed by updates.
In Excel for Mac, choose Help > Check for Updates and install available Office updates. If Excel was installed through the Mac App Store, check the App Store Updates tab instead.
Open System Settings > General > Software Update and install an available update compatible with your Mac. On older macOS versions, look for Software Update in System Preferences.
Reopen the workbook in Excel, select an affected PivotTable, and check whether its controls and PivotTable Fields pane are available.

Inspect the workbook's connections and refresh the data
Identify whether an external source or data model is preventing the Windows-created PivotTables from working on the Mac.
Rebuild the PivotTable from a worksheet data source
Use this approach when the original connection or data model cannot be used on the Mac.
Work with Excel-compatible spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for common Excel formats, making it easier to move everyday spreadsheet work between office suites. It does not fix unsupported Excel for Mac data models or connections.

Frequently Asked Questions
Why do new PivotTables work on my Mac while Windows-created ones do not?
The existing PivotTables may depend on an external connection or Windows data model that your Excel for Mac version does not support. Check Data > Connections on the Mac and Data > Queries & Connections in Excel for Windows.
Will updating Excel make an unsupported data source work?
An update may improve compatibility, but it does not guarantee support for every connection or data model. In Excel for Mac, choose Help > Check for Updates, then reopen the workbook and test it.
How can I refresh the affected PivotTables?
Open the workbook in Excel for Mac and choose Data > Refresh All. If Excel still reports an unsupported source, inspect the connection or rebuild the PivotTable from compatible worksheet data.
Can I rebuild a PivotTable without its original connection?
You can rebuild it if you can obtain the underlying data in a usable table. Put the data in a worksheet, select it, and choose Insert > PivotTable. Data model relationships and measures may need a different approach.




