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?