We help IT Professionals succeed at work.

How to add a pivot table structure to my list of recommended pivot tables?

How can I add a pivot table to my list of recommended pivot tables? Let's say I basically create the same pivot table every week - different data, same structure. How can I add it to my list of recommended pivot tables to make it easier to create? Thanks . Using Excel 2016
Comment
Watch Question

Roy CoxGroup Finance Manager

Commented:
Design a Table/PivotTable
Open the PivotTable Design Tools that are displayed when you click into the PivotTable
Extend the List.#
At the bottom click on New PivotTable Style to display this dialog
Custom-Pivot.png
Make any further changes then click OK

You can choose to make it the default style
Roy CoxGroup Finance Manager

Commented:
Forgot to say it will appear in Custom PivotTables at the top of the choices

Author

Commented:
Will this appear in the list of Recommended Pivot tables i.e. click on pivot table | Analyze | Recommended Pivot tables - just to the right of Pivot Charts?
Roy CoxGroup Finance Manager

Commented:
I don't think you can add to that Dialog. It stores it in the Custom styles.

I'll check some more for you.