Can get great performance during Excel Operations by enabling Multi Thread in Excel.

How to Set Number of Threads -

Office Button=>*Excel* Options=>Advanced=>Formulas '*Enable multi*=*threaded*

This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more

Hi Karan,

Is the option available in both 32 and 64-bit versions? I am using 32-bit version, I cheched the option you showed but still when performing big calculations, Excel is using exactly 25% of CPU (4-threaded). It seems like Excel is using only one thread. If it is so, then what for "Enable multi-threaded calculation" option is visible in 32-bit Excel?

Przemysław, I have exactly the same situation – I hope someone comes along with an answer.

32 and 64bit of excel has multithreaded enabled by default.

It is not all operations in excel capable for multithreading.

For example sorting will use only one core but applying a formula to a large amount of cells is capable for multithreading so you will see at the bottom bar of excel the number of cores currently used for this task.