ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table problems (https://www.excelbanter.com/excel-discussion-misc-queries/60046-pivot-table-problems.html)

[email protected]

Pivot table problems
 
I'm trying to create a pivot table and I'm having problems with 1
field. The error message reads:
A field in your data source has more unique items than can be used in a
pivot table. Can anyone help me find the problem? The pivot table
works fine up to 8000 rows. After 8,000 this error message appears.


Peo Sjoblom

Pivot table problems
 
Look in help for specifications, then look for pivot table report
specifications
you are allowed 32500 unique items

avoid putting numeric data fields as column or row fields,


here's a kb for 2002

http://support.microsoft.com/kb/820742/

--
Regards,

Peo Sjoblom

(No private emails please)


wrote in message
oups.com...
I'm trying to create a pivot table and I'm having problems with 1
field. The error message reads:
A field in your data source has more unique items than can be used in a
pivot table. Can anyone help me find the problem? The pivot table
works fine up to 8000 rows. After 8,000 this error message appears.




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

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