Free Support Forum -

Exception when adding large pivot table range

I’ve been receiving the following error when I try to create a pivot table from a large data set.

java.lang.IllegalArgumentException: Unkown Area: =Data1!A1:BI116010

which happens right after this block
PivotTables pivotTables = sheet.getPivotTables();
int index = pivotTables.add("=Data1!A1:" + lastCellName, “A1”, “PivotTable2”);

Funny thing is that I can create the pivot table just fine when I have fewer rows. I just created one successfully that has 59514 rows. I’m using version of the jar which I think may be the latest one. Can you help?


Could you attach your sample template Excel file here, we will check your issue soon.

Thank you.


If the workbook is a newly created one or loaded from xls files, please set its file format to excel2007 such as XLSX before you use formulas whose row/column reference exceeds xls file’s row/column limit.

Saving the file beforehand and setting the filetype to xlsx worked. Thank you.


It’s good to know your problem has been sorted out. If you have any other question, please feel free to post here.