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...
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.
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.