Pivot Table Data Range


Posted by Jeff on October 11, 2001 9:19 AM

As my data increases on a daily basis, I found that the original range used in the pivot table wizard is now not adequate to cover everything. When I edit the pivot table to include the new range I get a warning window stating:

Excel cannot make this change because there are too many rows or columns items. Drag off or alternatively hide.

How can I correct this? Hiding any items is not what I want to do. Is there anyway to modify the existing table or do we have to build a new one?



Posted by Eric on October 11, 2001 2:47 PM

The pivot table can't generat more than 8000 pivot rows

Otherwise, what I do is select the entire columns for the pivot table (e.g., instead of a1:d21 select a:d), and uncheck the blank category. Then whatever you add to the bottom of your pivot table is within range.
HTH