How to select all pivot items with .PivotItems(?????).Visible = True

[BOYAR]

Hi Everyone,

Im trying to find easy solution on how to select all Pivot items. Things is that my data base is updated with new entries very often so i need to refresh pivot and then open filters and click on "select all" each time, and then un-check "blanks"

What i have now is (and not working) :

Please Login or Register  to view this content.

Im not sure what is the proper command to be used instead of this "select all" ?

[xlnitwit]

Hi,

May I suggest the .ClearAllFilters method of the pivot field?

[BOYAR]

Could You please use my code and insert .ClearAllFilters in it with proper syntax etc? Im not that good with VBA - usually im recording macros and learn from it.

keep in mind that in the end i need to have this filter enabled :

.PivotItems("(blank)").Visible = False

as i do not want to have blank fields listed

[BOYAR]

Ok, found it

it worked, and code looks like this :

Please Login or Register  to view this content.