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


"mcarter" wrote:

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.