Stopping a pivot table from reformatting column sizes and widths

S

Schwimms

After I change a selection on the page column I dont want the pivot to
reformat the size of everything, because then I have to go back in there and
Minimize each column. It's annoying and cumbersome, is there a way to stop
this??
 
D

Debra Dalgleish

Right-click a cell in the pivot table
Click on Table Options
Remove the check mark from AutoFormat table
Click OK
 
Top