I need help understanding why when I create certain pivottables using
external data through our SQL server and use just a few fields that MS
provides an error stating that my pivottable is too big and that I've exceed
65,536 "items". Here is the catch, I know for a fact that data-wise, that I
won't consume more that 10,000 lines. Is there some hidden placeholders
shall we call them that causes my pivottable to be larger than it appears?
Knowing there is a 65536 line limit is there any work around without going to
Access? Thanks in advance!