ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table limit (https://www.excelbanter.com/excel-worksheet-functions/45969-pivot-table-limit.html)

Gilles Desjardins

Pivot table limit
 
Hi everyone,

Is the pivot table still limited to 8000 elements in Excel 2003?

Gilles



Anne Troy

Typing "limitations" in Excel 2003 help reports the following:

"Gilles Desjardins" wrote in message
...
Hi everyone,

Is the pivot table still limited to 8000 elements in Excel 2003?

Gilles




Anne Troy

(Sorry...sent my first post too early.)
Excel 2003 help on "limitations" reports the following:
PivotTable reports on a sheet--Limited by available memory
Unique items per field--32,500
Row or column fields in a PivotTable report--Limited by available memory
Page fields in a PivotTable report--256 (may be limited by available
memory)
Data fields in a PivotTable report--256
Calculated item formulas in a PivotTable report--Limited by available
memory
************
Anne Troy
www.OfficeArticles.com


"Gilles Desjardins" wrote in message
...
Hi everyone,

Is the pivot table still limited to 8000 elements in Excel 2003?

Gilles




Gilles Desjardins

Thank you Anne, Should have looked myself. Doh!

Gilles
"Anne Troy" wrote in message
...
(Sorry...sent my first post too early.)
Excel 2003 help on "limitations" reports the following:
PivotTable reports on a sheet--Limited by available memory
Unique items per field--32,500
Row or column fields in a PivotTable report--Limited by available memory
Page fields in a PivotTable report--256 (may be limited by available
memory)
Data fields in a PivotTable report--256
Calculated item formulas in a PivotTable report--Limited by available
memory
************
Anne Troy
www.OfficeArticles.com


"Gilles Desjardins" wrote in message
...
Hi everyone,

Is the pivot table still limited to 8000 elements in Excel 2003?

Gilles







All times are GMT +1. The time now is 01:21 AM.

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