Excel Performance Problems

How to Fix Excel Running Slow on M1 MacBook Pro

Huda QurayshiHuda Qurayshi Oct 29, 2026 870 views

Question details

Excel experiences significant lag and slow performance on an M1 MacBook Pro, particularly when calculating formulas like XLOOKUP and SUMIF.

How to Fix Excel Running Slow on M1 MacBook Pro
Product
Microsoft Excel
Device & OS
macOS (M1 MacBook Pro)
Scenario
Calculating formulas (XLOOKUP, SUMIF) or working with formatted workbooks.
Observed behavior
The application becomes very slow and unresponsive even when handling relatively small workbooks.
Before you start

Ensure your macOS and Microsoft Excel are updated to the latest versions optimized for Apple Silicon (M1) chips before proceeding with troubleshooting.

Solution 1Recommended

Boot in Safe Mode and Validate Fonts

Use Safe Mode to isolate font conflicts and clear font caches, which are common culprits for Excel slowdowns on Mac.

A large number of active fonts or corrupted font files can severely impact Excel's rendering speed on macOS. Starting your Mac in Safe Mode clears the font cache and helps identify if fonts or startup apps are causing the lag.

1
Restart in Safe Mode

Shut down your Mac. Press and hold the Power button until 'Loading startup options' appears. Select your main volume, press and hold the Shift key, then click 'Continue in Safe Mode'.

2
Test Excel Performance

Open the problematic workbook in Excel and test if the formula calculations are still slow. If the performance improves, the issue is likely font-related or caused by background apps.

3
Validate Fonts via Font Book

Restart your Mac normally. Open the 'Font Book' app from your Applications folder. Select all fonts, go to the top menu, and choose 'File' > 'Validate Font'.

4
Remove Problematic Fonts

Review the validation results and remove or disable any fonts marked with yellow warnings or red error icons.

Boot in Safe Mode and Validate Fonts
Tip: Limiting the variety of custom fonts used directly inside your Excel workbook can also help improve rendering speeds.
Free Microsoft Office alternative

Switch to WPS Office for Smooth Performance on Mac

If Excel continues to lag on your M1 MacBook Pro, consider trying WPS Office. It is a highly optimized, lightweight, and free office suite that runs smoothly on macOS and fully supports Microsoft Excel formats.

  1. 1. Download WPS Office: Visit the official WPS website and download the macOS version optimized for Apple Silicon.
  2. 2. Install the Application: Open the downloaded .dmg file and drag WPS Office into your Applications folder.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files to enjoy seamless formula calculation without the lag.
Native support for Apple Silicon (M1/M2/M3) ensuring fast performance.Highly compatible with Microsoft Excel (.xlsx) formats and complex formulas.Lightweight installation that consumes less RAM and system resources.Free to use with a familiar, tabbed user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why do formulas like XLOOKUP slow down Excel on my Mac?

Complex formulas like XLOOKUP or SUMIF require significant processing power, especially if they reference entire columns (e.g., A:A). Combined with heavy conditional formatting or memory constraints, this can cause significant calculation lag on macOS.

Can font conflicts really cause Excel to lag?

Yes. Excel loads system fonts when launching and rendering cells. Corrupted fonts, a massive number of active fonts, or a clogged font cache can force Excel to use excessive memory, leading to severe slowdowns.

Is 8GB of RAM enough for Excel on an M1 Mac?

For basic spreadsheets, 8GB is generally sufficient. However, if you are running multiple background applications or working with large workbooks containing complex arrays and conditional formatting, 8GB can easily become a bottleneck, causing Excel to slow down.