Hi Forum,
I use Pivots all the time & I like to have them display as Classic layout with no sub Totals.
Because Excel gives each Pivot Table a number, this means I need to manually go through & change the formatting when I'd rather write a VBA macro that could loop through all pivots and make these changes.
Has anyone worked out a way to do these steps using a variable name for the pivot table and a method make all Field Settings to 'None'.
Thanks
Bookmarks