Stop auto fit when using slicers

[dldeahl]

I have several pivots controlled by slicers. When I pick a filter the columns show ####. I cannot make it into a dashboard because I have to keep formatting the columns. I tried changing the format options in the pivot table but that did not work. The pivots hold time values if that matters.

 

[VeryForgetful]

Try the code below.

Right click the sheet with the pivot tables, click view code and paste this in.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Columns.AutoFit

End Sub

 

[dldeahl]

Try the code below.

Right click the sheet with the pivot tables, click view code and paste this in.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Columns.AutoFit

End Sub

Thanks I will give this a try!

 

[dldeahl]

I tried the code. Unfortunately it did not work.