Excel Performance Problems

Fix Excel for Mac High CPU Usage and Freezing When Editing a Workbook

Khadija KhanKhadija Khan Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open calculation preferences

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.

2
Select manual calculation

Under the calculation options, select Manual, then return to the workbook and try the edit that previously caused the freeze.

3
Recalculate when ready

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.

Switch Excel for Mac to manual calculation before major edits
Manual calculation is a workaround, not a guaranteed fix: Formula results can remain outdated in manual mode until you recalculate. The reporting user still experienced the issue after changing this setting.
Free Microsoft Office alternative

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.

Supports Microsoft Excel .xlsx and .xls formats.Offers a familiar spreadsheet interface for an easy transition from Excel.Lets you test workbook editing outside Excel for Mac without changing the original file.Provides a free, lightweight Office alternative for everyday spreadsheet work.
microsoft office alternative - wps office

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.