Forum Discussion
Claire Adams
Oct 18, 2017Copper Contributor
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