Save a custom pivot table style EXCEL

Question

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 ?!

Solution

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/

Comments

[Bandersnatch]

Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?

[HackSlash]

You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…