다음을 통해 공유

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

  • Anonymous
    January 21, 2013
    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?

  • Anonymous
    May 15, 2013
    Przemysław, I have exactly the same situation - I hope someone comes along with an answer.  

  • Anonymous
    May 02, 2014
    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.