Use a variable name for the pivot table to change format

[noboffinme]

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

[AliGW]

This duplicate thread is closed. Go here, please: https://www.excelforum.com/excel-pro...at-pivots.html