Cannot set default Pivot Formatting

Datafiltr Team
New Contributor



I am trying to set my default Pivot Table formatting as can be seen in the support article here:



I have the same issue as can be seen here:



Whereby I don't have 'Data' under the options.


I have data set in the 'Customize Ribbon' and am running version 1710 build 8625.2127.

3 Replies



Set PivotTable default layout is only available for Office 365 subscribers, it came to Excel with April 2017 updates for Office 365 thanks to Bill Jelen (Mr. Excel).


Follow this link:

Allow users to set/choose defaults (via settings) for PivotTables - Layout (compact, tabular, classi...


Make sure that you have Office 365 subscription with version 1704 (Build 8067.2115) and above!

Please note that the Data tab in Excel options is new and it came with this update.


The support article linked above (https://support.office.com/en-gb/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9d...) clearly states that it applies to Excel 2016.




I sent them a feedback about this as follows:

"The PivotTable default layout feature is only available for Excel 2016 with Office 365 subscription, you should explain this so that people do not think it available in Excel 2016 as a one-time purchase."

Related Conversations
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies