2003 Pivotal Tables

[JL]

Using 2003 Execl Pivotal Tables and received following
pop-up:

A field in your source data has more unique items than
can be used in a PivotTable report. Microsoft Office
Excel may not be able to create the report, or may create
the report without the data from this field.

What is the max. unique items can be in a field? I have
41566 unique records.

 

[Harald Staff]

Hi

I believe the limitation is that your report can't exceed the max amount of rows (65 536).
In this case, you could theoretically ask for a subtotal for each item, resulting in 83132
rows. Even if you don't, the lady suspects it and denies it.

 

[JL]

Harlad,

If what you said is true I shouldn't be getting the
message. I even try reduced amount of records down to
37450 rows and was still getting the same message.

Best regards,
Jimmy

-----Original Message-----
Hi

I believe the limitation is that your report can't

exceed the max amount of rows (65 536).

In this case, you could theoretically ask for a subtotal

for each item, resulting in 83132

 

[Harald Staff]

Well, I may be wrong, stranger things happen as we speak. But is that field your only one
? If you have one more, say "year", with three items 2001, 2002, 2003, then you might
possibly ask for one subtotal for each item for each year -kaboom; 224 700 theoretical
rows.

 

[JL]

There are 4 columns, ApplicationID, Amount, Org, and
Date; the problem column is ApplicationID which has
unique number. If I don't include ApplicationID in the
Pivot Table, I won't get the message.

-----Original Message-----
Well, I may be wrong, stranger things happen as we

speak. But is that field your only one

? If you have one more, say "year", with three items

2001, 2002, 2003, then you might

possibly ask for one subtotal for each item for each

year -kaboom; 224 700 theoretical

 

[Colleyville Alan]

Using 2003 Execl Pivotal Tables and received following
pop-up:

A field in your source data has more unique items than
can be used in a PivotTable report. Microsoft Office
Excel may not be able to create the report, or may create
the report without the data from this field.

What is the max. unique items can be in a field? I have
41566 unique records.

You may be getting that reply if you accidentally dragged the field to the
column drop area instead of the row drop area.

 

[Myrna Larson]

If you search Help for Specifications, you'll find the following, which indicates that you can
have at most 8,000 items in the report. I'm not entirely sure what an "item" is -- the number of
cells in the body of the table???

Excel specifications and limits
PivotTable report specifications

Feature Maximum limit
PivotTable reports on a sheet Limited by available memory
Items in a PivotTable report 8,000
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

 

[JL]

I have tried many times and still getting the same
message. My workaround was to reduce the records to
approx. 37100 rows.

 

[Guest]

I'm not sure about 8000 items either. But I do know if I
have less then 37100 rows of records I won't recieve the
message.

-----Original Message-----
If you search Help for Specifications, you'll find the

following, which indicates that you can

have at most 8,000 items in the report. I'm not entirely

sure what an "item" is -- the number of

cells in the body of the table???

Excel specifications and limits
PivotTable report specifications

Feature Maximum limit
PivotTable reports on a sheet Limited by available memory
Items in a PivotTable report 8,000
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

 

[Colleyville Alan]

(e-mail address removed)> wrote in message

I'm not sure about 8000 items either. But I do know if I
have less then 37100 rows of records I won't recieve the
message.

Per Microsoft:

Maximum Number of Items for Each Pivot Field
There is a limit of 32,500 unique items for each row field, column field, or
page field. If you try to drop a field that exceeds this limit into your
PivotTable report, the field is not added to the PivotTable report, and you
may receive the following warning message: A field in your source data has
more unique items than can be used in a PivotTable report. Microsoft Excel
may not be able to create the PivotTable report or may create the PivotTable
report without the data from this field.


http://support.microsoft.com/default.aspx?scid=kb;en-us;820742&Product=ofw#appliesto