Copying date from one sheet to another sheet using script.

Error 507 could have many reasons, in general that's incompatibility of applications running at the same time. Script could run another PDF conversion while previous one is not finished, or you work with protected mode, whatever.

It's not clear what script is doing for 2 minutes. For above code that's one second job. Do you run it from cloud flow or manually within workbook. Is workbook protected. If script are where other steps in it.

I'd tried also slightly modified version

function main(workbook: ExcelScript.Workbook) {
    const dataRange = "A1:D18"
    const source = workbook.getWorksheet("Tn8453").getRange(dataRange)
    const target = workbook.getWorksheet("Report8453").getRange(dataRange)

    const application = workbook.getApplication()

    application.setCalculationMode(ExcelScript.CalculationMode.manual) // in general not necessary, just in case
    target.copyFrom(source, ExcelScript.RangeCopyType.values)
    target.copyFrom(source, ExcelScript.RangeCopyType.formats)
    application.setCalculationMode(ExcelScript.CalculationMode.automatic)

}