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