VBA Excel hangs when running more than 10 instances on Windows Server.

Question

Hello,

We are running VBA Excel Macros on a lab server with Windows Server and HPC Pack installed.

After upgrading to the latest version and performing a fresh installation,

we encountered an issue where Excel, which previously worked fine, is no longer functioning properly.

The previous versions we were using were Windows 2016, HPC Pack 2016, and Excel 2016,

while the newly installed versions are Windows 2019, HPC Pack 2019, and Excel 2019.

We are running one instance of Excel per core for parallel processing.

With the 2019 version, everything works fine up to 8 cores,

but starting from 10 cores, about 4 out of the 10 Excel instances stop working and freeze.

To test the software, we downgraded the Excel version to 2016, but the same issue occurred.

(In the 2019 version, Excel hangs and stays frozen, while in the 2016 version, Excel hangs and then closes after a short time.)

For OS testing, we installed Windows 10 on a VM, and it worked up to 16 cores without any issues.

If there are any solutions or similar cases regarding this situation, please let us know.

Thank you.