Autoformat in pivot tables

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

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.
 
Select a cell in the pivot table, and choose Format>AutoFormat
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.
 
Back
Top