Pivot Table

[Guest]

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??

 

[Nick Hodge]

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)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)