Pivot Table and Compatibility Mode

Question

My company uses a commercial application to track the training our associates take.  One of the reports that is pulled contains a few of the fields that are populated.  There are 3 date fields, a name field, a manager name field and a score field. 

When the report is generated, it is in the form of an Excel list. The file is an XLS file and it indicates Compatibility Mode on the Title Bar .   We use Excel 2010 (Windows 7) and save it to XLSX format.  It remains in compatibility mode.

On a recent data run, about 30,000 rows were populated.  The analyst would then do a pivot table to summary.  She is able to add the two name fields and one date field.  All the rows are present.   The widest field is a date-time field.  When she tries to add a fourth field, she gets an error that the Pivot Table will not fit on one worksheet/  How can she correct this problem. 

Thank you

Paul

Answer 1

Read the article at the link given below.

The article says - The product of the number of items in all column fields in a PivotTable cannot exceed 32,768.

I am not sure whether this limit is also linked to the Excel version ( I mean different for Excel 2007, Excel 2010 , and so on).

Check what is your count ? Is it within the permisible limit ?

https://support.microsoft.com/en-us/kb/211517#/en-us/kb/211517

Hope this is Helpful.