ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table capacity in 2000 or 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/65354-pivot-table-capacity-2000-2003-a.html)

Martin

Pivot Table capacity in 2000 or 2003
 
I've got a pivot table with 26 columns and 1532 rows (based on data of 60
cols by 30,000 rows). In version 2000, when I add another field I get the
error message "Excel cannot make this change because there are too many row
or column items...". I've obviously hit a limit (clearly higher than the
8000 items mentioned in Help). If I upgrade to version 2002 or 2003, will
this problem go?


All times are GMT +1. The time now is 07:02 AM.

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