What is the maxium source range for pivot table

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

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Adding to an existing Pivot Table 7
How can I change the source data reference to another pivot table? 2
Pivot tables - memory issues - please help 2
Pivot Table Ranges 8
Referencing a pivot tables Grand Totals Column 1
Pivot Table - 3

Back
Top