Excel has only three threads to enable multithreaded computing

Question

Excel has only three threads to enable multithreaded computing

J Working 0

My laptop is Huawei Matebook 14.The computer processor is i5-1240p.

When I use Excel to calculate the formula, the number of threads displayed is only 3. Then I found that in my Excel options, "Use all processors on this computer" displays only 3. As far as I know, the number of threads in my processor should be far more than 3.

For this question, I asked the support staff of Excel. After trying, he suggested that I come here for help.

I want to know why my Excel can only use 3 threads. Is it related to the processor of my computer? Is the number of threads in my Excel normal? Can I increase the number of threads？

I hope someone can answer my question. Thanks. 微信图片_20230116112509

Viorel 122.6K Reputation points

2023-01-16T15:21:22.5+00:00

Did you confirm the number of processors using Task Manager (https://support.microsoft.com/en-us/windows/find-out-how-many-cores-your-processor-has-3126ef99-0247-33b3-81fc-065e9fb0c35b)?

You can also go to the Details tab, right-click EXCEL.EXE, "Set affinity", and verify the processor affinity.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2023-01-30T09:54:21.2433333+00:00

Hi @J Working,

I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 answer

Your answer

Viorel 122.6K Reputation points

2023-01-16T15:21:22.5+00:00

Did you confirm the number of processors using Task Manager (https://support.microsoft.com/en-us/windows/find-out-how-many-cores-your-processor-has-3126ef99-0247-33b3-81fc-065e9fb0c35b)?

You can also go to the Details tab, right-click EXCEL.EXE, "Set affinity", and verify the processor affinity.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2023-01-30T09:54:21.2433333+00:00

Hi @J Working,

I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Hi @J Working,

"Is it related to the processor of my computer? "

As far as I know it's related to the computer performance and how many threads Excel can recognize.

"Is the number of threads in my Excel normal? "

The number of calculation threads you have is normal, and the number of calculation threads that my excel can recognize in my computer is 2.

User's image

"Can I increase the number of threads？"

You can change the number of calculation threads manually:

User's image

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Excel has only three threads to enable multithreaded computing

1 answer

Your answer