pivot table question

[Harvey Waxman]

When I try to drag a column heading to the table Excel says "A field in your source data has more unique items than can be used in a pivot table." I let Excel select the range (from A1 to O10792)

Is there a limit? I didn't see anything about that.

 

[John McGhie]

Yes, there is a limit.

Without knowing your software version level, we can't tell you what it is.

When I try to drag a column heading to the table Excel says "A field in your
source data has more unique items than can be used in a pivot table." I let
Excel select the range (from A1 to O10792)

Is there a limit? I didn't see anything about that.

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[Harvey Waxman]

I'm using Excel 10.1.9 OSX

I have 10,000 rows and selected half of them and the error stopped.
Can you suggest a really basic step by step tutorial to setting up and using the table? What I have seen online assumes too much.

 

[John McGhie]

Hi Harvey:

I think you've hit a hard limit. From the Excel Help:

€ 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
Pages in a PivotTable report 8,000

Try this link: http://www.cpearson.com/excel/pivots.htm

Or this one:
http://oreilly.com/windows/archive/whatisapivottable.html

Hope this helps

I'm using Excel 10.1.9 OSX

I have 10,000 rows and selected half of them and the error stopped.
Can you suggest a really basic step by step tutorial to setting up and using
the table? What I have seen online assumes too much.

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[Harvey Waxman]

Hi Harvey:

I think you've hit a hard limit. From the Excel Help:

€ 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
Pages in a PivotTable report 8,000

Try this link: http://www.cpearson.com/excel/pivots.htm

Or this one:
http://oreilly.com/windows/archive/whatisapivottable.html

Thanks a bunch