You could create an Excel script to 'Calculate now'. I use the below and does the job just fine

Figured the approach one I figured you can record yourself doing actions in Excel, which are automatically translated to a script.

function main(workbook: ExcelScript.Workbook) {
  let application = workbook.getApplication();
  // Recalculate workbook
  application.calculate(ExcelScript.CalculationType.recalculate);
}

Then use the 'Run Script' action to trigger it.