PivotTable compatibility with earlier versions of Excel

PivotTables created in Excel for Mac 2011 will lose some functionality when opened in earlier versions of Excel.

When you share the workbook with users that are running Excel for Mac 2011 and earlier and Excel 2007 for Windows and earlier, filters will not be available, and data may not refresh as expected. Previous PivotTable limits have also been extended. The new limits are not compatible with earlier versions and data that exceeds earlier limits will not be displayed.

The limits are shown in the following table:

PivotTable feature


Number of rows

New: 1,048,576

Old: 65,536

Number of columns

New: 16,384

Old: 255

Number of data fields

New: 16,384

Old: 255

Number of report filters

New: 16,384

Old: 255

Unique items in a single PivotField

New: 1,048,576

Old: 32,500

Length of field name

New: 32,767 characters

Old: 255 characters

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.