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:
Number of rows
Number of columns
Number of data fields
Number of report filters
Unique items in a single PivotField
Length of field name
New: 32,767 characters
Old: 255 characters