HPC com Excel

Question

HPC com Excel

Renato Thomaz 0

Ola, estou com dificuldade em executar tarefa entre 3 computadores, sendo que os 3 computadores já estão conectados, 2 no windows serve 2019 e o nó principal está com windows 10, quando Clico em New Job e configuro *test.bat * um teste retirado da internet funciona normalmente, as 3 CPU trabalhar para executar essa tarefa e parece 100% concluída, só que não consigo colocar as 3 máquinas para executar juntas uma macro de Excel, ou seja as 3 CPU trabalharem ao mesmo tempo em uma macro de Excel no nó poderia, poderia me ajudar?

Jiajing Hua 18,140 Reputation points Moderator

2024-05-28T06:34:41.75+00:00

Hi @Renato Thomaz

According to translation tool, do you want to increase CPU usage when running VBA code?

Please go to File > Options > Advanced > Formulas section. Make sure "Enable multi-threaded calculation" is turned on, "Use all processors ..." is also selected.

But please note, starting from Excel 2010, there are specific scenarios for multi-core processing, such as saving, opening files, refreshing pivot tables, etc. For more details, please refer to following link: https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-performance-and-limit-improvements#multi-core-processing

Other references:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-utilize-multiple-cores-in-excel-2016/76fef7bb-750d-42f7-95ca-91d2694479c1

Renato Thomaz 0

Hello, maybe I didn't understand the question, I'm referring to Cluster HPC, I'm not able to process the same VBA macro together on the 3 computers at the same time

Your answer

Jiajing Hua 18,140 Reputation points Moderator

2024-05-28T06:34:41.75+00:00

Hi @Renato Thomaz

According to translation tool, do you want to increase CPU usage when running VBA code?

Please go to File > Options > Advanced > Formulas section. Make sure "Enable multi-threaded calculation" is turned on, "Use all processors ..." is also selected.

But please note, starting from Excel 2010, there are specific scenarios for multi-core processing, such as saving, opening files, refreshing pivot tables, etc. For more details, please refer to following link: https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-performance-and-limit-improvements#multi-core-processing

Other references:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-utilize-multiple-cores-in-excel-2016/76fef7bb-750d-42f7-95ca-91d2694479c1
Renato Thomaz 0 Reputation points

2024-05-28T22:51:42.2433333+00:00

Hello, maybe I didn't understand the question, I'm referring to Cluster HPC, I'm not able to process the same VBA macro together on the 3 computers at the same time

Share via

HPC com Excel

Your answer