Easy Computer Tips & Tricks

Step 1: Click 'FILE' and select 'Options' to open Excel Options dialog box. Step 2: Click 'Formulas' from the Excel Options dialog box. Step 3: Select 'Manual' below the Calculation options. That’s it. , Select Recalculate workbook before saving NOTE: If you don’t want to turn off the automatic calculation feature, and you have multiple processors in your computer, you can turn on the multi-threading feature, which could speed up the recalculation of your formulas by a little bit, depending on how many processors your computer has.

Microsoft Excel Comes with a Multi-threading feature that can reduce the time taken to calculate complex formulas. then turning On this feature will let Excel to make use of multiple processors to perform the calculations faster. What if your computer doesn’t feature multiple processors? Then you can follow this guide to disable automatic calculations performed whenever you open a worksheet or make any changes to the formulas. For the rest who own powerful computer, here’s how you can enable Multi-Threading. Step 1: Click 'FILE' and select 'Options' to open Excel Options dialog box. Step 2: Select 'Advanced' from the Options dialog box. Step 3: Scroll down to 'Formulas' section and check 'Enable multi-threaded calculation'. You can manually specify how many threads to use or let Excel to use all processors available in your computer.

Go to File —> Options —> Save then change the minutes for Saving the Auto Recovery.