How to Change the Automatic Calculation and Multi-Threading Features in Excel 2013?

In Microsoft Excel 2013 when any modification is done in the entries or in formulas of the worksheet, this application automatically execute the recalculations of present formulas. No doubt automatic calculation is effective feature but most of time it takes few minutes to fulfill the process. During recalculation process we don’t perform any other activity and have to wait for the completion of this action. This procedure consumes more time when worksheet is very long and consist on too much formulas.

To overcome this issue, Excel facilitates us by turning off the automatic calculations. This will save our time unless and until we finished the entering and changing the formulas in our Excel’s sheet. But if we don’t turn off this feature and have various processors in our PC then turn on Multi-Threading feature which help us to speed up the process of recalculation.

Now in this article we will learn how to change automatic calculation and multi-threading feature by following the particular steps.

Disable Automatic Calculation Feature:

• Open Microsoft Excel
• Click > File Tab.

• Go to > Option command in the menu from the bottom of left side.

• Excel option dialog box will open
•  Select > Formulas button also from left.

• Scroll down in box and reach > Calculations option.
• Check >Radio button of Manual instead of Automatic
• Automatic calculation feature disable.

Enable Multi-Threading Feature:

• Click > File Tab.
• Go to > Option command in the menu from the bottom of left side.
• Excel option dialog box will open
• Select > Advanced in the menu from left.

• Scroll in the box and Go to > Formulas Section.
• Click in the check box of > Enable multi-threaded calculation.
• Feature of multi-thread calculation enable.