Help!
Appologies if this has already been answered before (looked but I could not find). I need to speed up some code that works on a VERY large pivot table (real db not an option).
I need to insure all pivot items in a pivot field are not hidden. I know I can use the hiddenitems property to show each hidden item in VB, but this is very slow (especially if there are a lot of hidden items in the field).
Is there a way (VB only) that will "SHOW ALL" items (changing the pivotitem.visible = false to true) all at one time?
Thanks greatly
Appologies if this has already been answered before (looked but I could not find). I need to speed up some code that works on a VERY large pivot table (real db not an option).
I need to insure all pivot items in a pivot field are not hidden. I know I can use the hiddenitems property to show each hidden item in VB, but this is very slow (especially if there are a lot of hidden items in the field).
Is there a way (VB only) that will "SHOW ALL" items (changing the pivotitem.visible = false to true) all at one time?
Thanks greatly