View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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