Excel 365 Dynamic Arrays, LAMBDA Functions, and HPC

Question

Back in the day, there was talk about sending an Excel spreadsheet to an HPC cluster, such as the article, "Accelerating Excel with Microsoft HPC Pack : Building VBA Applications and Workbooks for a Microsoft HPC Pack". But now you have introduce LAMBDA functions and Dynamic arrays to give an ever more functional programming feel. If the spreadsheet was only modified to use lambda/let functions and dynamic arrays - essentially writing the spreadsheet as pure as possible, would this improve the performance and parallelization of a spreadsheet on the HPC cluster or even on the desktop? Would this be a good reason to switch to a more functional style of writing an Excel spreadsheet?