hey all.. is there a way you can reset all the pivot tables fields to showall ..

im guesssing.. record a macro that would make the options to select all and then assign it to a button..

is dere any other way beacuse i need to reset them in all the sheets
some sorta vba ? maybe

thanks for the help