What is the maxium source range for pivot table

P

Paul

I have a data table that has 2300 rows and 16 columns. When I create a pivot
table and pivot chart it is only recognizing 719 rows and 16 columns
 
M

mzehr

Hi Paul,
It sounds like additional data was introduced to the data range after the
pivot table was originally set up. Go back into Pivot table wizard and
double check the data range, and redefine it accordingly. I have used pivot
ranges that are over 10 times that size with no problem.
 
Top