hi there,

i have a pivot table with over 4000 entries and about 12 columns which i filter to get the info i want.

Unfortunately with so many rows and columns in the table, if i do a macro that gets each filter back to 'show all' its really slow.

Doing this manually using the "Show all" option in the filter takes a fraction of a second, so surely there must be a way to do this more quickly in VBA?

i can't understand why manually it takes no time at all, but automating it through recording a macro takes forever.