Microsoft Excel 2010 has a multi threading feature which when enabled reduces the time taken for complex calculation or Formulas. And you can enable this feature when your computer supports multi processing capabilities. Listed below are the steps to enable or disable multi threading feature in Excel 2013 and Excel 2010
Step 1: Click File menu and select Options from the list.
Step 2: In the Options window, click Advanced tab and scroll down to Formulas section.
Step 3: Now you can enable or disable multi threading feature by using the checkbox with label Enable multi-threaded calculation. This also provides option for specifying the number of processor that has to be used for the calculation. By this way Excel users can turn on or off multi threading feature.
I am unchecking the multi thread option by taking this rout but the option is not getting applied across all the files. When I open a large file, this option gets checked back.