changing the default settings of pivot table

There is also an extensive gallery of PivotTable styles. Note that the PivotTable Style Options section of the ribbon controls elements of the styles that you will see in the Styles gallery as well as the style of the active PivotTable. You can choose to emphasise row and column headers and to 'band' rows and columns. The style gallery then provides a range of colours and presentations, split into Light, Medium and Dark variants. The 2007 Live Preview feature allows you to see the effect of any of the styles on the active PivotTable just by hovering over it before you need to select it. Finally, at the bottom of the PivotTable Styles dropdown, there are options to Clear the style of the current PivotTable and to create a New PivotTable Style. The latter option lets you specify the format for each individual element of the PivotTable >>>>>>>>and also to set the style created as the default PivotTable quick style for this document. The PivotTable Style Gallery is also dependent on any overall workbook theme set via the Themes option of the Page Layout ribbon.
www.accountingweb.co.uk/

Not me, I googled it...