Pivot Tables Resizing Columns

P

PeterH

I am working with pivot tables. When I introduce another variable into the pivot table or run a show pages to create individual reports based on a field, it seems to change all the fonts and resize all of the columns and the like. Is there any way to lock this down so that the columns and formats are the same for all pages in the workbook

Any help would be most appreciated.
 
A

Andy Brown

Rightclick the table & choose "Table Options" from the pop-up menu.

Uncheck "AutoFormat Table".

HTH,
Andy
 
Top