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...
Generally I use the Pivot Table and PivotChart Wizard quick access button.
I just did standard Insert>Pivot Table and it DID work! is there another quick access button that would work? Small request but would be great if MS could fix that.
Appreciate the clue into getting this working!!
Appreciate the clue into getting this working!!
- Hi! I am still having the same issue where new pivot tables are not using the custom default settings I edited. How did you get it to work? Just Insert>Pivot table isn't working for me. 😞
- 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
I have a similar issue, and is even weirder in my case.
If I insert a pivot using Insert-->Pivot Table, it works
But if I do Alt+D+P (shortcut for insert pivot) and then Alt+F (which is Finish) then it still uses the old layout.
I normally prefer using keyboard shortcuts and not clicking.
Any solution to this?
- You could just right-click the button on the insert tab and select add to QAT.
