Hi ,

I have created excel file with exceljs along with DataValidation. When I open the file and change the any cell It's taking a minute to save.

Excel having 2000 rows and 20 drop downs.

Datavalidation code is
Cell.dataValidation = {
type: 'list',
allowBlank : true, formulae:=Sheet2!$${sourceOfValuesColumn}$1:$${sourceOfValuesColumn}$${splitedValues.length}`],
showErrorMessage: true,
errorStyle: 'error'
}
If I delete any row and save it's saving in a second.