Fix Pivot Charts That Do Not Update in Excel for Mac 2011
Question details
The user wants to update PivotCharts in a downloaded workbook using Excel for Mac 2011.

- Product
- Microsoft Excel for Mac 2011
- Device & OS
- Mac
- Scenario
- A workbook created in a newer version of Excel contains data, PivotTables, and PivotCharts that the user wants to update on a Mac.
- Observed behavior
- The PivotCharts do not update, and Excel does not display an Enable Editing message.
In Excel, check the version under Excel > About Excel and confirm that the affected chart is a PivotChart linked to a PivotTable. If you use a newer Excel version, make sure it is updated before testing the workbook.
Open and refresh the workbook in a newer Excel version
Use a supported version of Excel for Mac when you need to update the existing PivotCharts.
Excel for Mac 2011 supports PivotTables but not PivotCharts. Office 2011 is discontinued and will not receive an update that adds PivotChart support. The absence of an Enable Editing message does not change this limitation.
Open the downloaded workbook in an updated version that supports PivotCharts, such as Excel for Mac 2016 or later.
Click the PivotTable linked to the chart, then use PivotTable Analyze > Refresh. If the workbook uses an external data source, reconnect when prompted.
Select the PivotChart and confirm that it reflects the refreshed PivotTable, then use File > Save to keep the changes.

Create a standard chart from PivotTable results
Use this workaround in Excel for Mac 2011 if you only need a chart of the summarized values, not an interactive PivotChart.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday workbook work to another suite. It does not add PivotChart support to Excel for Mac 2011; check complex workbook features before switching.

Frequently Asked Questions
Does Excel for Mac 2011 support PivotCharts?
No. Excel for Mac 2011 supports PivotTables but not PivotCharts. Open the workbook in an updated version of Excel for Mac that supports PivotCharts to update them.
Which versions of Excel for Mac can update PivotCharts?
Updated versions of Excel for Mac 2016 and later support PivotCharts. Open the workbook in a newer version and use PivotTable Analyze > Refresh to update the linked PivotTable.
Can an Office 2011 update add PivotChart support?
No. Office 2011 is discontinued, and its updates do not add PivotChart support.
Why is there no Enable Editing message?
The presence of an Enable Editing message depends on how Excel opens the file. Its absence does not enable PivotCharts in Excel for Mac 2011 or explain away the version's feature limitation.
Can I chart PivotTable data without a PivotChart?
Yes. Copy the PivotTable results to a regular worksheet range, select the copied data, and choose a chart from the Charts tab. Update the copied values after refreshing the PivotTable.




