Thursday, November 05, 2015

Make custom Pivot Table Style available in multiple Excel files

When you create a custom Pivot Table Style, it remains available only for the file it was created in. If you try to apply the same style to a different file you'll realize that the custom style doesn't appear in the list of available styles for new file. 

In order to transfer the custom style or to save it for other Excel files, follow these steps:

1. Select the entire pivot table (Select --> Pivot Table) where the custom style is already applied and copy (Ctrl+C). 
2. Paste this pivot table in a temporary sheet in a new file or your destination file. 
3. The custom style will now appear in the list of available styles. 
4. Delete the copied pivot table.