// Create a new workbook Workbook workbook = new Workbook(); workbook.open(this.getResourceStream("xlsx/Urban Centers 2017.xlsx")); Workbook flints = new Workbook(); flints.open(this.getResourceStream("xlsx/Flints.xlsx")); Workbook jackson = new Workbook(); jackson.open(this.getResourceStream("xlsx/Jackson.xlsx")); Workbook petrosky = new Workbook(); petrosky.open(this.getResourceStream("xlsx/Petrosky.xlsx")); workbook.getWorksheets().get(0).getRange("B6:E11").setFormula("='[Flints.xlsx]Sheet1'!B7+'[Jackson.xlsx]Sheet1'!B6+'[Petrosky.xlsx]Sheet1'!B7"); workbook.updateExcelLink("Flints.xlsx", flints); workbook.updateExcelLink("Jackson.xlsx", jackson); workbook.updateExcelLink("Petrosky.xlsx", petrosky); workbook.calculate(); // Save to an excel file workbook.save("CrossWorkbookFormula2.xlsx");