Format pivot table / column width

[mcarter]

How do I keep the column width the same after I select a new value in a pivot
table? after I select a new value to filter the data, it changes the column
widths and I have to change them back every time i select a new value to
filter.

 

[Teethless mama]

Highlight Pivot Table > right click > select Table Options > tick on Preserve
formatting > OK out

 

[mcarter]

I have the preserve formatting on...

Highlight Pivot Table > right click > select Table Options > tick on Preserve
formatting > OK out