New Pivot Table default is forgotten

Occasional Visitor

Hi

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?

 

Thanks

0 Replies