I'm creating a pivot table for a very large amount of data (46,000 rows and about 20 columns). I'm using 6-8 of the columns as row filters, and then below in the data table there will be 8-10 columns of data. It will be the entire 46,000 lines row length.

I tried to create the pivot table, dragging the fields I wanted in the pivot table field list "Report filter" section and "Row labels" section. I took away subtotals. As I tried to drag all the fields I needed into the report filter and row labels sections, I got the following error message:

"A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Excel may not be able to create the report, or may create the report without the data from this field."

I wasn't able to even drag in several of the fields I needed, and only 27,000 of my 46,000 rows of data are displayed.

Is there truly a maximum on amount of data you can include in a pivot table, or is there a way to make this work?

Thanks for your help