Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,195 questions
HPC com Excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Renato Thomaz
0
Reputation points
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?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST 7,705 Reputation points Microsoft Vendor2024-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:
-
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
Sign in to comment