How do you turn off pivot table auto format in Excel?

I want to know how to return to the original/default pivot table format after
I have already applied an auto format report style.

In the list of AutoFormats, select PivotTable Classic, which is at the
bottom of the AutoFormat list.

srudd wrote:
> I want to know how to return to the original/default pivot table format after
> I have already applied an auto format report style.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I have tried this and it does not get me back to the original format. I want
to return to the format with the data elements listed in row mode instead of
across columns.

"Debra Dalgleish" wrote:

> In the list of AutoFormats, select PivotTable Classic, which is at the
> bottom of the AutoFormat list.
>
> srudd wrote:
> > I want to know how to return to the original/default pivot table format after
> > I have already applied an auto format report style.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

Apply one of the Table AutoFormats first, e.g. Table 8.
Then apply the PivotTable Classic AutoFormat
You may have to rearrange some of the fields manually, if it doesn't
return to the layout that you want.

srudd wrote:
> I have tried this and it does not get me back to the original format. I want
> to return to the format with the data elements listed in row mode instead of
> across columns.
>
> "Debra Dalgleish" wrote:
>
>
>>In the list of AutoFormats, select PivotTable Classic, which is at the
>>bottom of the AutoFormat list.
>>
>>srudd wrote:
>>
>>>I want to know how to return to the original/default pivot table format after
>>>I have already applied an auto format report style.
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html