I've searched this forum high & low and can't find a reasonable answer for this, and the Goog doesn't help me either. I can't possibly be the first one asking about this though, just exhausted my resources or I'm not asking the right question or search criteria...
So here it is, in my pivot table I cannot get my "Item List" to go past 10,000 items shown. How can I change this? The error message is simple "this field has more than 10,000 items under one or more parent items."
Redundant to that, seemingly anyway, is the ability to use the search box in that item list, HOWEVER, I cannot save more than just the item I'm searching for by checking that specific box. So every time I search for a specific item, I then 'check it', then it proceeds to kill all the previously checked items I needed for my table...
Somebody help me out? I feel, and hope, this is an easy fix that I'm simply missing. Or in my "upgrade" to office 2010 did I lose the ability to have a long list??
Any help is more than appreciated! Thanks for even reading my issue.
Bookmarks