If you’ve decided to use the Manual calculation option, you can recalculate formulas any time you want by either pressing the F9 key, or clicking the Calculate Now or Calculate Sheet button on the Formulas tab of the Excel ribbon. The Calculate Now button will update all open worksheets, while the Calculate Sheet button will only update the active worksheet and any charts linked to that sheet.
As we mentioned before, one of the reasons that people choose the Manual calculation option is because of the length of time it takes these calculations to complete in large workbooks. However, if your computer has more than one processor, you may be able to reduce this time by instructing Excel to use all processors when performing calculations.
Return to the Excel Options window and select Advanced. Scroll through the options until you see Formulas.
Put a check in the box next to Enable multi-threaded calculation. You can now specify exactly how many processors you want Excel to use when performing calculations. Keep in mind, though, if you are running other processor-intensive applications at the same time as Excel, enabling this option could slow them down.
Related Reading: If you’re looking for more Excel tips and tricks, check out the other user guides and tutorials available on Bright Hub’s Windows Channel. Learn how to create a dropdown list or read through any of the articles on chart and graph design. More items are being added on a regular basis so check back often!