PivotTable report specifications
|
Feature |
Maximum limit |
|
PivotTable reports on a sheet |
Limited
by available memory |
|
Distinct
Row Items in a PivotTable report |
8,000
/ 32000 in Excel 2003 / limited by Memory in Excel 2007 ** |
|
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 |
Charting
specifications
|
Feature |
Maximum limit |
|
Charts
linked to a worksheet |
Limited
by available memory |
|
Worksheets
referred to by a chart |
255 |
|
Data series
in one chart |
255 |
|
Data points
in a data series for 2-D charts |
32,000 |
|
Data
points in a data series for 3-D charts |
4,000 |
|
Data points
for all data series in one chart |
256,000 |
|
Line
styles |
8 |
|
Line
weights |
4 |
|
Area
patterns (screen display) |
18 |
|
Total
area pattern and color combinations (color display) |
56,448 |
|
Pattern
and color combinations (color printer) |
56,448
(the actual number depends on your printer and its software) |
|
Page
fields in a PivotChart report |
256
(may be limited by available memory) |
|
Data
fields in a PivotChart report |
256 |
|
Calculated
item formulas in a PivotChart report |
Limited
by available memory |
** Number
of distinct row items in Pivot table is 8000. There is no limit on the number
of records in external data source. Normally in compre
Further memory constraints of desktop do not play important role with use of ERPJewels because ERPJewels transforms the data in production server and MS Excel has to handle only summary distinct rows.
Source - MS Excel help for limitations of MS Excel 2002 and subsequent enhancements knowledge
FastTrack to ERPJEWELS :
Latest Trend | Hot Links | Jewels of ERPJewels | Jewels of Baan | Jewels of Excel