Forum Discussion

Claire Adams's avatar
Claire Adams
Copper Contributor
Oct 18, 2017

New Pivot Table default is forgotten

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

No RepliesBe the first to reply

Resources