How to move a pivot table style to another file

Let’s take a look.

Here we have the custom pivot table style that we created and applied to this pivot table earlier.

Wed like to use this same style in a different workbook.

To make this pivot table style available in another workbook, just follow this simple workaround.

First, opt for entire pivot table.

it’s possible for you to use the Select menu on the Options tab of the PivotTable Tools Ribbon.

Choose Select, and 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 created as you paste.

Now check that the custom style is available on the Design tab of the PivotTable Tools ribbon.

You should see the new style in the workbook.

Just right-snag the worksheet and choose Delete.

you might now apply the custom style to your pivot table.

Just select any cell in the table, and apply the style normally.