Pivot table problem

  • Thread starter Thread starter Gershon Shamay
  • Start date Start date
G

Gershon Shamay

I need to create a pivot table [all rows, no columns] from a table of 11
columns. I can add at most 5 rows in the pivot table's Layout. Trying to add
more result sin an error message "too many row or column items".
Where does the limitation come from and how do I remove it / extend it ?

Regards,

Gershon Shamay
 
Perhaps you could move some of the fields into the page area.

The following MSKB articles outline PivotTable limitations for different
versions of Excel:

XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?id=211517

Limits of PivotTable Reports in Microsoft Excel 2003
http://support.microsoft.com/default.aspx?id=820742


Gershon said:
I need to create a pivot table [all rows, no columns] from a table of 11
columns. I can add at most 5 rows in the pivot table's Layout. Trying to add
more result sin an error message "too many row or column items".
Where does the limitation come from and how do I remove it / extend it ?

Regards,

Gershon Shamay
Click to expand...
 
Back
Top