Locking column width in excel file

[Sundance_Kid]

Hi, I have a pivot table with multiple columns, most of the columns have numbers in them but a couple of the columns would have text.

When I go to refresh the pivot, depending on the length of text in one of the rows in the column the width of the colum will automatically expand to fit all the text in.

Is there a way to freeze the width of the column without preventing the user from refreshing the file or filtering on it?

Thanks

 

[Peter_SSs]

Try this
Right click somewhere on the PT and choose 'Pivot Table Options ...' then make sure that this option is not ticked.