Thread: Stopping a pivot table from reformatting column sizes and widths
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote