Excel: How to Enable Multi Thread in Excel 2010

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


Comments (3)

  1. Przemysław says:

    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?

  2. Jael says:

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

  3. Marios says:

    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.