Forum Discussion
Setting Default Pivot Table Options does not work (Excel 2016?)
Hello All, I recently discovered the new feature in Excel 2016 that allows you to set the default options for pivot tables in Options>Data>Edit Default Layout>PivotTable Options. I was very exci...
The default only works for "modern" pivot tables, it does not work for "old style" pivots inserted using the old school pivot table and pivot chart wizard
Okay, understandable. So how do I insert a "modern" pivot table?
- It should work on pivots inserted using the button on the Insert tab of the ribbon as far as I know. Check out Excel Options, is there a Data tab there which has a button to edit the default?
- Yes. I was able to complete all of the steps to edit the default layout of the pivot tables.
I cannot figure out why it won't work. The videos I watched showing me how to edit the default layout don't show this problem at all and I followed them step by step.- Odd indeed.