New Pivot Table default is forgotten

Occasional Visitor


I'm using the new 365 feature to set my default pivot style via File>Options>Data>Edit Default Layout.


When I 'import' via a cell in a pivot table style I've created (my new colours!), the default holds true for that workbook, but the new default isn't available when I open another workbook - existing or new.


I think the manual settings persist (e.g. Report Layout>Show in Tabular Form), but not the styling I've imported.


So, it would seem that I need to recreate my preferred pivot style (i.e. colours) in each and every workbook?



0 Replies