Setting Default Pivot Table Options does not work (Excel 2016?)

Occasional Contributor

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 excited because I am always changing the same options for every single pivot table i create (classic view, show zero for error or missing data, don't adjust column width etc).  It saves my settings in the option screen but when i create a new pivot table they just revert to the standard options.

Has anyone gotten this to work?


5 Replies
Precisely how do you insert the Pivot Table? Do you use Insert, Pivot table? Is your workbook saved as xlsm or xlsx?

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!!
You could just right-click the button on the insert tab and select add to QAT.
Did not know you could do that either - Thank you!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Discussion - Updating our interface with Fluent touches
Elliot Kirk in Discussions on
102 Replies