Stopping a pivot table from reformatting column sizes and widths

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
Right-click a cell in the pivot table
Click on Table Options
Remove the check mark from AutoFormat table
Click OK
 
Back
Top