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.

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" <(E-Mail Removed)> wrote in message
news6491465-DAC4-457D-B50F-(E-Mail Removed)...
>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.

thank you for your kind reply.
this however removes all the formatting of the table, which is what i would
like to avoid.
i guess it is not possible to customise an autoformat then?

e.


"Bernie Deitrick" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news6491465-DAC4-457D-B50F-(E-Mail Removed)...
> >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.
>
>
>

e.,

Another option is recording a macro where you set the column widths, and then run the macro after
the table refresh.

HTH,
Bernie
MS Excel MVP


"user3307" <(E-Mail Removed)> wrote in message
news:C1D20F4D-1B66-4B62-B889-(E-Mail Removed)...
> thank you for your kind reply.
> this however removes all the formatting of the table, which is what i would
> like to avoid.
> i guess it is not possible to customise an autoformat then?
>
> e.
>
>
> "Bernie Deitrick" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news6491465-DAC4-457D-B50F-(E-Mail Removed)...
>> >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.
>>
>>
>>

good idea, thanks.

"Bernie Deitrick" wrote:

> e.,
>
> Another option is recording a macro where you set the column widths, and then run the macro after
> the table refresh.
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "user3307" <(E-Mail Removed)> wrote in message
> news:C1D20F4D-1B66-4B62-B889-(E-Mail Removed)...
> > thank you for your kind reply.
> > this however removes all the formatting of the table, which is what i would
> > like to avoid.
> > i guess it is not possible to customise an autoformat then?
> >
> > e.
> >
> >
> > "Bernie Deitrick" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news6491465-DAC4-457D-B50F-(E-Mail Removed)...
> >> >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.
> >>
> >>
> >>
>
>
>

Another option is to insert a blank row above your pivot table and add
characters to the cells to achieve the correct column width when the column
is autofit. Since auto format autofits the columns you will ned up with the
correct spacing...
--
HTH...

Jim Thomlinson


"user3307" wrote:

> good idea, thanks.
>
> "Bernie Deitrick" wrote:
>
> > e.,
> >
> > Another option is recording a macro where you set the column widths, and then run the macro after
> > the table refresh.
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> >
> > "user3307" <(E-Mail Removed)> wrote in message
> > news:C1D20F4D-1B66-4B62-B889-(E-Mail Removed)...
> > > thank you for your kind reply.
> > > this however removes all the formatting of the table, which is what i would
> > > like to avoid.
> > > i guess it is not possible to customise an autoformat then?
> > >
> > > e.
> > >
> > >
> > > "Bernie Deitrick" wrote:
> > >
> > >> 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" <(E-Mail Removed)> wrote in message
> > >> news6491465-DAC4-457D-B50F-(E-Mail Removed)...
> > >> >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.
> > >>
> > >>
> > >>
> >
> >
> >