Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,793 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Our Excel add-in code is now getting a timeout error while updating cells in sheets exceeding 3500 rows. Despite smooth operation before, this issue has surfaced suddenly. We are investigating the root cause and working towards resolving it to restore full functionality to our Excel add-in. We welcome any suggestions or insights. Thanks in advance!
Excel.run(function (context) {
var sheet = context.workbook.worksheets.getActiveWorksheet();
var rangeValues = [];
resultColumnCells.forEach((element, index) => {
rangeValues.push(sheet.getRange(element));
let data = [dataArray[index]];
rangeValues[index].values = data;
rangeValues[index].format.autofitColumns();
})
return context.sync();
}).catch(function (errorHandlerFunction) {
console.error(errorHandlerFunction.code);
console.error(errorHandlerFunction.message);
});