Hi @nleuck_101
May be put a delay before retriving the rows present after refreshing so that data can get loaded to sheet in some time.
Or do a refresh again using the same script after a delay , this can be done by using a loop , like making the run script action to run two times , each time providing a delay after refresh.
Or if it does not work, could you try with below office script instead
function main(workbook: ExcelScript.Workbook) {
// Get the Excel application
let excelApp = workbook.getApplication();
// Calculate all formulas in the workbook
excelApp.calculate(ExcelScript.CalculationType.recalculate);
console.log("Refresh All complete.");
}
Let me know whether it works for you !
