Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column Resizing and Pivot Tables
Does anyone out there get frustrated when updating or changing a pivot table
causes all columns in the worksheet to be resized? Does anyone know how to turn this "resizing" feature off? |
#2
|
|||
|
|||
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTableTable Options Add a check mark to 'Preserve formatting', click OK Remove the check mark from AutoFormat Table Click OK Schmeebs wrote: Does anyone out there get frustrated when updating or changing a pivot table causes all columns in the worksheet to be resized? Does anyone know how to turn this "resizing" feature off? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|