Adding SAVE to a script

[asjmoron]

Hi all.

I am working a spreadhseet that needs to automatically updated each morning with no manual intervention.

Through resarch (the al mighty google) I have found a power automate process. It says it runs sucsessfully but the actual spreadsheet does not update. I am wondering if it is because the script it is using has no save function?

I am using the below script which is being called by power automate.

function main(workbook: ExcelScript.Workbook) {
    // Refresh all data connections
    workbook.refreshAllDataConnections();
}

Any Ideas?