Pivot Table Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a pivot table by importing data from an external
source. It is essentially a list of thousands of products and their
respective prices. However, when I try to add the column 'products', I
receive an error message that states: "A field in your data has more unique
items than can be used in a PivotTable report. Microsoft Office Excel amy not
be able to create the report, or may create the report without the data from
this field."
I do not know how to fix this.
I would appreciate any help.
 
The most likely issue is your pivot table has more than 65,536 rows
(this is the max # of rows in Excel 2003 and lower).

Try re-arranging the data in your pivot table or removing the
subtotals to reduce the # of rows in your table.
 
Tim, thanks for your hlep. Before I import the data into the pivot table
there are about 55,000 rows. So I am assuming the limitation of 65,000 rows
is exceeded when the subtotals are entered. How do I get rid of the subtotals?
 
Back
Top