Limitation of Excel Pivot Table 2013 VS 2010 Vs 2007

We all use the PivotTable for multiple purpose like summarization in context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a data in excel and below are some major limitations will may help you to understand here limiation of Excel Pivot Table 2013 VS 2010 Vs 2007 are same.

Pivot Table	Maximum limit
Value fields in a PivotTable report	256
Value fields in a PivotChart report	256
Items displayed in filter drop-down lists	10000
Length of the MDX name for a PivotTable item	32767
Length for a relational PivotTable string	32767
Unique items per field	1048576
Report filters in a PivotTable report	256 (may be limited by available memory*)
Report filters in a PivotChart report	256 (may be limited by available memory*)
PivotTable reports on a sheet	Limited by available memory *
Row or column fields in a PivotTable report	Limited by available memory *
Calculated item formulas in a PivotTable report	Limited by available memory *
Calculated item formulas in a PivotChart report	Limited by available memory*

Note: Limited by available memory* is the amout of system memory (RAM) avaliable to process the request. MDX stands for Multi dimensional Expressions

Source : https://support.office.com/