Changing the Default PivotTable Style in Excel 2007
When you create a pivot table in Excel 2007, a PivotTable Style is automatically applied. You always select a different PivotTable Style, so you'd like to change the default PivotTable Style, to save time when you create new pivot tables.
Follow these steps to change the default PivotTable Style:
- Select a cell in the pivot table.
- On the Ribbon, under the PivotTable Tools tab, click the Design tab.
- In the PivotTable Style gallery, right-click on the style that you want to set as the default.
- In the context menu, click on Set As Default.
___________________________
For more information on pivot tables, see the Pivot Table Topics on my Contextures web site.
Hi Debra,
In addition to the Style gallery,
is there a simple way to set all the various parameters of the pivot table display options ?
Thanks for your help
Carim
Hi Carim, not that I know of. You can use the Style gallery, or create a macro to format the pivot table.
Debra
Hi Debra,
I have been trying to set a default PivotTable design in Excel 2007.
I have tried the steps above but it does not seem to work. Any idea what I may be doing wrong?
Alan
@Alan, if the file was originally saved with pivot tables, in Excel 2003 format, then converted to Excel 2007, the classic Excel layout persists, and override the 2007 pivot styles.
If that’s the problem, try copying the source data to a new workbook, and create the pivot tables there.
That may well be it. Ill check it out.
Thanks Debra.