Vrftjkry

I went to the effort of creating a custom pivot table design, to match my companies work colours.

I'm looking for a way to save a custom table style (not Workbook) as a template, so it can be used in other workbooks.

I have done this with several charts, which can then be used again, so was hoping it is also possible with a Pivot Table .

I have found a work around for this, I can copy the original created template and paste it into a new workbook, the design is then available to use, but surely there must be a way of saving the actual design ?!

There is, but it ain't pretty:

1. Copy a Table/PivotTable that uses the new Table Style into a new
   blank workbook.


2. Setting that Table/PivotTable Style as the Default Style


3. Delete that Table/PivotTable


4. Save the workbook as an Excel Template in the Startup folder, so
   that Excel will use this workbook – and your beautifew new Custom
   Table/PivotTable Style – as a template whenever you create a new
   document.

Read more at my blogpost at http://dailydoseofexcel.com/archives/2015/02/27/custom-table-styles/

Excel provides no way of transferring custom pivot table styles,
so transferring a custom style to new documents is difficult if it is
not already included in the template as described in the
answer by @jeffreyweir.

If you wish to transfer a custom style without using a document template,
this is done as follows.

Excel version from before 2016

1. In any workbook containing the custom style, select any cell in the
   pivot table that has that custom style applied.


2. On the Ribbon's Options tab, in the Actions group, click Select, and then click Entire PivotTable


3. On the Ribbon's Home tab, click Copy.


4. Switch to the new workbook.


5. Select a blank worksheet, or insert a new blank worksheet.


6. Select cell A1 on the blank worksheet.


7. On the Ribbon's Home tab, click Paste.


8. Delete the sheet that contains the pasted copy of the pivot table.

Your custom PivotTable style now appears in the PivotTable Styles gallery,
in the new workbook.

Excel version 2016

Unfortunately, in Excel 2016 the above method does not work and the custom
pivot table style is not copied. The following method works in
Excel 2016 and also in Excel 2013.

1. Open the old workbook with the pivot table that has the custom style applied.


2. Open the new workbook where you want to add that custom style


3. Position the workbooks, so you can see the sheet tabs in both files


4. Press Ctrl and drag a copy of the pivot table sheet from the old workbook into the new workbook.


5. The custom style is now copied into the new workbook, and you can delete the sheet that you copied from the old workbook.

For more detailed information and screenshots see the article
Excel Pivot Table Format - Copy Custom Style to Different File.