ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Tables - # of Columns (https://www.excelbanter.com/excel-discussion-misc-queries/77644-pivot-tables-columns.html)

David

Pivot Tables - # of Columns
 
I have put 5 things on the row side and 16 on the sum side, but when I want
to add another item on the row side the wizard tells me to delete one of the
other items, is there a limitation like this, any help would be greatly
appreciated.

David

Debra Dalgleish

Pivot Tables - # of Columns
 
There's information on the pivot table limits he

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel (2002-2003)
http://support.microsoft.com/default.aspx?id=820742


David wrote:
I have put 5 things on the row side and 16 on the sum side, but when I want
to add another item on the row side the wizard tells me to delete one of the
other items, is there a limitation like this, any help would be greatly
appreciated.

David



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com