Issue with Excel Add-In Code: Timeout Error

Question

Issue with Excel Add-In Code: Timeout Error

Nirogini Albertjanstin 0

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);
    });

Jan Karel Pieterse 161 MVP

Why are you writing values one cell at a time? It is far more efficient to build an array of values and write them to the range of cells in a single statement.

Something like this:

Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();

    // Build the two-dimensional array required by Range.values.
    const values = dataArray.map(value => [value]);

    // Use the first destination cell as the top-left cell.
    const firstCell = resultColumnCells[0];
    const rowCount = values.length;

    const startRange = sheet.getRange(firstCell);
    const targetRange = startRange.getResizedRange(rowCount - 1, 0);

    // Write all values to Excel in one operation.
    targetRange.values = values;
    targetRange.format.autofitColumns();

    await context.sync();
}).catch((error) => {
    console.error(error.code);
    console.error(error.message);
});

1 answer

Your answer

Jan Karel Pieterse 161 Reputation points MVP

2026-08-05T12:56:43.8766667+00:00

Why are you writing values one cell at a time? It is far more efficient to build an array of values and write them to the range of cells in a single statement.

Something like this:

Excel.run(async (context) => { const sheet = context.workbook.worksheets.getActiveWorksheet(); // Build the two-dimensional array required by Range.values. const values = dataArray.map(value => [value]); // Use the first destination cell as the top-left cell. const firstCell = resultColumnCells[0]; const rowCount = values.length; const startRange = sheet.getRange(firstCell); const targetRange = startRange.getResizedRange(rowCount - 1, 0); // Write all values to Excel in one operation. targetRange.values = values; targetRange.format.autofitColumns(); await context.sync(); }).catch((error) => { console.error(error.code); console.error(error.message); });

Answer 1

AXRO Felix 0

Good Day,

ist there any update on this problem? We are still facing the same problem .

Best regdars

Felix

0 comments