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

image


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.

Skip to main content