G
Guest
Guest
On occasion I create pivot tables which have several unique values (>100) in each field. I often need to filter my pivot table for only one or two unique values in a certain field. The only way to do this is to manually "uncheck" all the unique values I want filtered out of my pivot table. This can be very time consuming when you have several unique values. I found that using the down arrow and spacebar (on my keyboard) allows me to manually "uncheck" the boxes faster, however, this is still manual. Does anybody know how to shorten this process using VBA? Is their another way?
Thanks,
RVences
Thanks,
RVences