Run excel script timing out - delete rows

(1) Share

Report

Posted on by JoeWright

I'm trying to run a simple script via powerautomate to delete rows in a table however it just times out. Strangely it did work once (I haven't changed anything). The number of rows to delete is about 700.

Error: We were unable to run the script. Please try again.
Office JS error: Line 4: Table deleteRowsAt: The request is aborted.

Here's the script:

function main(workbook: ExcelScript.Workbook) {

let myTable = workbook.getTable("All_Months");

let rowCount = myTable.getRowCount();

myTable.deleteRowsAt(0, rowCount);

}

Any help much appreciated!!

All responses (1)

Answers (0)

JoeWright 4 on at

Like (0)

Report

Re: Run excel script timing out - delete rows

When directly clicking run script in excel online it had an error/timeout at line 4 yet when I did the same in the desktop app it worked