Following the release of the
Microsoft Office 365 update to Excel 2016 version 1612 (January 25, 2017), there
has been a change in Excel’s default behaviour in relation to PivotTable subtotals when a
new field is created following a Group operation. Until now, the new field has
been created with the subtotals set to “None”. Now, the new field will be
created with the subtotals set to “Automatic”.
I haven’t checked whether the
same change occurs with subscription versions of Excel
2013.
