Pivot Table SubTotal method does not work

Aug 6, 2013 at 2:18 AM
I set the field column subtotal to "None". However, the excel show error "Excel found unreadable content. After I click "Yes" to open the excel, the subtotal method is set to "Automatic", not "None".

How can I solve this problem?
            OfficeOpenXml.Table.PivotTable.ExcelPivotTableField rowField = pivotTable.Fields[1];
            rowField.SubTotalFunctions = OfficeOpenXml.Table.PivotTable.eSubTotalFunctions.None;
            if (isTabularForm)
            {
                rowField.Outline = false;
                rowField.Compact = false;
            }

            pivotTable.RowFields.Add(rowField);