• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to enable or disable multi threading feature in Excel

September 9, 2014 by Admin 1 Comment

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.

enable or disable multi threading feature in Excel 2013 and Excel 2010

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.

Also See: How to turn off auto calculation in Excel 2010

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Calculation, Excel 2010, Formulas, multi thread, Multi-threaded, Office 2010

Reader Interactions

Comments

  1. Vish says

    August 19, 2022 at 12:15 am

    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.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023