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.