SQL BI

My Experience - Troubleshooting SQL BI Stack

Excel: How to Enable Multi Thread in Excel 2010

Excel: How to Enable Multi Thread in Excel 2010

  • Comments 3

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
  • 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.

Page 1 of 1 (3 items)
Leave a Comment
  • Please add 5 and 8 and type the answer here:
  • Post