I've already try to find something similar on this forum about pivot table with no luck. My question is when I used this statement 'pivotTable1.AddFieldToArea(PivotFieldType.Data, 34)', my excel sheet crashes. I try to repair it but pivot table is not there. But everything works great if I use statement ' pivotTable1.AddFieldToArea(PivotFieldType.Data, 33); Is there a limit on column data?
I'm using Aspose cells version 4.4 with Excel 2007. Do I need to send sample program?