Pivot Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ivan - 26 Oct 2004 04:15 GMT

I got an error when creating a Pivot Table:

"A field in your source data has more unique 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"

Any way to fix this problem??

Reply to this Message

Nick Hodge - 30 Oct 2004 10:10 GMT

Ivan

I don't wish to state the obvious, but you will need to use less unique
items in your pivot table.

Excel can only display a field with less that 32,000 unique items, so you
will need to leave out the field that is causing it to go above that number,
for example, leave out an item# field and summarise by division instead
(group of item numbers of similar type, for example)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>I got an error when creating a Pivot Table:
>
[quoted text clipped - 3 lines]
>
> Any way to fix this problem??

Reply to this Message