Exceljet

Quick, clean, and to the point
From the video: How to move a pivot table style to another file

How to move a pivot table style to another file

Unfortunately, there is no built-in way to move a custom pivot table style to another workbook. However, there is a simple workaround you can follow when you want to use the style again in a different workbook.

Lets take a look.

Here we have the custom pivot table style that has been created and applied to this pivot table. We’d like to use this same style in a different workbook. But when we check the pivot table styles menu, the custom style not listed, and there is no obvious way to import or copy the style.

To make this pivot table style available in another workbook, just follow this simple workaround. First select the entire pivot table. You can use the Select menu on the Options tab of the PivotTable Tools Ribbon. Choose Select, then Entire PivotTable.

Next, copy the pivot table to the clipboard.

Now navigate to the other workbook and create a new blank worksheet. Then paste the pivot table into the new worksheet. The custom style will be be created as you paste.

Check that the custom style is available on the Design of the PivotTable Tools ribbon. You should see the new style in the workbook, highlighted.

Now that the custom style is available in the second workbook, you can remove the pasted pivot table. Just right-click the worksheet and choose Delete.

You can now apply the custom style to your pivot table. Just select any cell in your pivot table, and and apply the style normally.

Related shortcuts

Author 
Dave Bruns
I'm an intermediate-level Excel user - I only know as much as I need to get the job done. As I imagine is the case for most people, I learned Excel by asking myself questions like, "I wonder if there's a way to do [X]?" and then Googling the answer. Your site has already taught me so much in the short time I discovered it and, as a Learning & Development professional, I admire your approach. Great work, and thanks for supporting all us Excel geeks! -Will
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course