agwalsh
asked on
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
Forgot to say it will appear in Custom PivotTables at the top of the choices
ASKER
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?
I don't think you can add to that Dialog. It stores it in the Custom styles.
I'll check some more for you.
I'll check some more for you.
ASKER
Got this as a workaround. https://www.myonlinetraininghub.com/set-excel-pivottable-default-layout
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Make any further changes then click OK
You can choose to make it the default style