From Debra Dalgleish:

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off, then click OK


HTH,
Bernie
MS Excel MVP


"user3307" wrote in message
...
i have chosen an autoformat for my pivot table, but would like to change the
column width (also after refreshing).
is this possible?

thanks.
e.