Found it.

In Pivot table options set AutoFormat to False (off) but leave preserve
formatting to True.




"DKS" wrote:

Hi,

Very frustrating: each time I do a refresh of the Pivot table, Excel resets
the column width. How can I get excel to remember the column width that I
have set or that i want to set?

Many thanks in anticipation.