• 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

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel

blogmines.com Copyright © 2023