Pivot table column widths

  • Thread starter Thread starter DKS
  • Start date Start date
D

DKS

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.
 
Found it.

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