Stopping a pivot table from reformatting column sizes and widths
 

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??

Stopping a pivot table from reformatting column sizes and widths
 

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

Schwimms wrote:
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??



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html