Pivot Table Resizing

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
W

Wayne Burritt

Hi: I have a pivot table with a lot of columns. I resize the columns so I
can view all the data but every I display a new row of data, the columns
jump back to their old size. Any ideas on how I can keep the column width
constant? thx Wayne
 
Turn off AutoFormat in the PivotTable, and the column width adjustments
should be retained:

Right-click on a cell in the PivotTable
Choose Table Options
Remove the check mark from AutoFormat Table
Click OK
 
Wayne

I used to have the same problem so what I did is I wrote a
macro that sets the column width to what ever it is in row
1 for that column... you have to dedicate row 1 to this
but for me it paid back...

heres the code...
'==========================================
Sub ColumnWidth()
Application.ScreenUpdating = False
Dim A As Integer
For A = 1 To 256
If Cells(1, A).Value > 0 Then
Cells(1, A).ColumnWidth = Cells(1, A).Value
Else
End If
Next A
Application.ScreenUpdating = True
End Sub
'===========================================

I have a button with this macro assigned so every time I
update the Pivot-Table, then I click the button and vuala!

Cheers
Juan
 
Back
Top