A computer can have more than one processor (it contains multiple physical processors) or can be hyperthreaded (it contains multiple logical processors). On these computers, you can improve or control the time it takes to recalculate workbooks that contain many formulas by setting the number of processors to use for recalculation. In many cases, portions of a recalculation workload can be performed simultaneously. Splitting this workload across multiple processors can reduce the overall time it takes complete the recalculation.
- Click the Microsoft Office Button
, click Excel Options, and then click the Advanced category.
- To enable or disable the use of multiple processors during calculation, in the Formulas section, select or clear the Enable multi-threaded calculation check box.
- Note This check box is enabled by default and all processors are used during calculation. The number of processors on your computer is automatically detected and displayed next to the Use all processors on this computer option.
- Optionally, if you select Enable multi-threaded calculation, you can control the number of processors to use on your computer. For example, you might want to limit the number of processors used during recalculation if you have other programs running on your computer that require dedicated processing time.
How to control the number of processors
- Under Number of calculation threads, click Manual. Enter the number of processes to use.
Note The maximum number is 1024.