How to Fix Excel Running Slow on M1 MacBook Pro
Question details
Excel experiences significant lag and slow performance on an M1 MacBook Pro, particularly when calculating formulas like XLOOKUP and SUMIF.

- 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.
Ensure your macOS and Microsoft Excel are updated to the latest versions optimized for Apple Silicon (M1) chips before proceeding with troubleshooting.
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.
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'.
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.
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'.
Review the validation results and remove or disable any fonts marked with yellow warnings or red error icons.

Monitor Memory Usage and Background Apps
Identify if limited RAM or conflicting startup software is bottlenecking Excel's formula calculation.
Review and Simplify Workbook Formatting
Excessive conditional formatting and background colors can severely degrade performance.
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. Download WPS Office: Visit the official WPS website and download the macOS version optimized for Apple Silicon.
- 2. Install the Application: Open the downloaded .dmg file and drag WPS Office into your Applications folder.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files to enjoy seamless formula calculation without the lag.

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.




