Automatic Subtotal Pivot Table suddenly quits

Copper Contributor

Multiple pivot tables drawn from one data source. Excel (Office 365 - 32 bit) automatically inserted a Months subtotal before Date labels either in Rows or Columns depending on layouts.

 

Worked perfectly until I got beyond about 100,000 rows of data. Automatic Subtotals still selected in Field Properties but Months no longer shows above field name in either Columns or Rows depending on layout.

 

Dates either all in October or spread across September/October 2020 depending on filters.

 

Any thoughts?

0 Replies