Autoformat in pivot tables
 

Does anyone know if it is possible to remove an autoformat from a pivot table
once the document is saved? I would like to return the pivot table to its
original form before the autoformat. Thanks.

Autoformat in pivot tables
 

Select a cell in the pivot table, and choose FormatAutoFormat
Scroll to the bottom of the list of AutoFormats, and click on PivotTable
Classic
Click OK

If you had previously applied one of the Report AutoFormats, e.g.
Report4, any column headings would have been automatically moved to the
Row area.
You'll have to manually move those fields back to the Column area.

C Tate wrote:
Does anyone know if it is possible to remove an autoformat from a pivot table
once the document is saved? I would like to return the pivot table to its
original form before the autoformat. Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html