I get This error message

Mar 1st, 2002, 11:08 AM

i whant to create a pivot table from a sheet that has 5 colums and 39442 rows and get this error" a field in your source data has more items than can be used in a pivot table. microsoft excel may not be able to create the pivot table, or may create the pivot table without the data from this field". PLEASE help me
thank you

Mark W. · Mar 1st, 2002, 12:10 PM

The maximum number of "items" that a PivotTable can have is 8,000. To understand what an item is look at the Excel Help topic for "Parts of a PivotTable". Item examples are shown in yellow. So let's say that one of your PivotTable fields consists of 8,001 unique date values and you wanted to display them all. That would exceed this limit.

Mar 3rd, 2002, 08:32 AM

Thank you Mark for your quick reply
I did work with worksheets that have a lot more than 8000 items with no problem. On Friday I made a Pivot Table with 25000 and had no problem. I selected the first 25000 rows of this file as the range and had no problem. I'm using Excel 97 SR1

Mar 4th, 2002, 10:31 AM

You are right the first 25000 rows had less than 8000 unique items
Thank you very much for your help it is greatly appreciated

deuxo · Mar 28th, 2002, 06:23 PM

I s there a wau to measure the number of unique items in a database that will result in a limit with a pivot table? i am running into this problem and my database has 10000 cells but I don't know the number of unique items.

Dave Hawley · Mar 28th, 2002, 08:30 PM

Hi deuxo

Have you had a play with Advanced Filter?

nisht · Mar 28th, 2002, 08:45 PM

Friend,

I have a file nos.5 and 22 which can help you to extract unique values.

You can see the code fro file nos.22.

I hope this can help you to extract unique value.

http://www.pexcel.com/download.htm

And thank you board.. i came to know that pivotal table takes 8000 unique values only.

And yes before you use this code..please take the backup of your original file.
nishith desai
http://www.pexcel.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 11:08 AM	#1
Guest Posts: n/a	i whant to create a pivot table from a sheet that has 5 colums and 39442 rows and get this error" a field in your source data has more items than can be used in a pivot table. microsoft excel may not be able to create the pivot table, or may create the pivot table without the data from this field". PLEASE help me thank you

Mar 1st, 2002, 12:10 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	The maximum number of "items" that a PivotTable can have is 8,000. To understand what an item is look at the Excel Help topic for "Parts of a PivotTable". Item examples are shown in yellow. So let's say that one of your PivotTable fields consists of 8,001 unique date values and you wanted to display them all. That would exceed this limit.

Mar 3rd, 2002, 08:32 AM	#3
Guest Posts: n/a	Thank you Mark for your quick reply I did work with worksheets that have a lot more than 8000 items with no problem. On Friday I made a Pivot Table with 25000 and had no problem. I selected the first 25000 rows of this file as the range and had no problem. I'm using Excel 97 SR1

Mar 4th, 2002, 10:31 AM	#4
Guest Posts: n/a	You are right the first 25000 rows had less than 8000 unique items Thank you very much for your help it is greatly appreciated

Mar 28th, 2002, 06:23 PM	#5
deuxo New Member Join Date: Mar 2002 Posts: 13	I s there a wau to measure the number of unique items in a database that will result in a limit with a pivot table? i am running into this problem and my database has 10000 cells but I don't know the number of unique items.

Mar 28th, 2002, 08:30 PM	#6
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi deuxo Have you had a play with Advanced Filter?

Mar 28th, 2002, 08:45 PM	#7
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Friend, I have a file nos.5 and 22 which can help you to extract unique values. You can see the code fro file nos.22. I hope this can help you to extract unique value. http://www.pexcel.com/download.htm And thank you board.. i came to know that pivotal table takes 8000 unique values only. And yes before you use this code..please take the backup of your original file. nishith desai http://www.pexcel.com