Fix Excel for Mac High CPU Usage and Freezing When Editing a Workbook
Question details
The user needs to reduce high CPU usage and freezing in Excel for Mac when editing a workbook with many complex Boolean expressions.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS; the reported issue persisted on macOS 10.15.6
- Scenario
- Inserting columns or making other major changes to a workbook containing formula-heavy worksheets, including Boolean expressions used for Internet searches.
- Observed behavior
- Excel consumes all available CPU and becomes unresponsive. Switching to manual calculation did not resolve the issue for the reporting user, and updating to Office 16.39 and macOS 10.15.6 did not help.
Identify the worksheet containing the complex Boolean expressions and the edit that triggers the freeze. Note the current calculation mode so you can restore it after testing.
Switch Excel for Mac to manual calculation before major edits
Use this first to reduce automatic recalculation during column insertions and other structural changes; it may not resolve every freeze.
Before inserting columns or making major edits, open Excel > Preferences > Calculation. In versions that use Settings instead of Preferences, look for Calculation under Excel > Settings.
Under the calculation options, select Manual, then return to the workbook and try the edit that previously caused the freeze.
After completing your edits, use Formulas > Calculate Now to update formula results. If you no longer need manual mode, return to the calculation settings and select Automatic.

Test the workbook without the formula-heavy worksheet
Use a controlled comparison to check whether the worksheet containing complex Boolean expressions is contributing to the slowdown.
Reduce or isolate the complex Boolean formulas
Use this if manual calculation does not help or testing points to the formula-heavy worksheet.
Try WPS Spreadsheet for your Excel workbook workflow
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface and support for Excel formats. Open a copy of your workbook to evaluate a smooth migration, but verify complex formulas and performance: WPS does not repair Excel for Mac's CPU or freezing issue.

Frequently Asked Questions
Why does Excel for Mac use so much CPU when I insert columns?
Column insertions can require Excel to update formula references and recalculate dependent cells. A workbook with many complex Boolean expressions may create a heavy workload. Test a copy without the formula-heavy worksheet to see whether it contributes to the slowdown.
Where do I turn on manual calculation in Excel for Mac?
Open Excel > Preferences > Calculation and select Manual. Some versions label Preferences as Settings. Make this change before inserting columns or performing other major edits.
What should I try if manual calculation does not stop the freezing?
Use File > Save As to create a test copy, remove the worksheet containing the complex expressions from that copy, and repeat the same edit. If performance improves, simplify the formulas or move the search-expression workload to a separate workbook.
Will my formulas keep updating in manual calculation mode?
Not automatically after every edit. Use Formulas > Calculate Now when you need updated results, or return to Excel > Preferences > Calculation and select Automatic to restore automatic calculation.
Will updating Office or macOS fix this issue?
An update may address version-specific defects, but it is not a guaranteed fix. In this report, updating to Office 16.39 and macOS 10.15.6 did not help. Use Help > Check for Updates to check Excel updates, then also test calculation settings and the formula-heavy worksheet.




