Fix Excel for Mac Crashing with SORT and FILTER Formulas
Question details
The user needs to prevent Excel for Mac from crashing when a worksheet calculates nested SORT and FILTER formulas.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Calculating a worksheet containing nested SORT and FILTER formulas.
- Observed behavior
- Excel crashes during worksheet calculation.
Note the Excel version and build number under Excel > About Microsoft Excel. Identify the affected formula and the ranges it references so you can test them separately.
Update Excel and simplify the SORT and FILTER formula
Use this approach to rule out an outdated build and reduce the formula's calculation scope.
In Excel, choose Help > Check for Updates and install available updates. If Excel was installed through the Mac App Store, check the App Store's Updates section instead.
Choose File > New Workbook, enter a small sample of the source data, and test the FILTER and SORT formulas there. Check whether calculation still causes a crash.
In an empty helper cell, enter the FILTER portion of the original formula. In another empty area, enter SORT referencing the helper cell's spill range; for example, use =FILTER(A2:C100,B2:B100="Open","") in E2 and =SORT(E2#) in I2.
Edit the formulas in the formula bar to replace full-column references such as A:A with bounded ranges such as A2:A100 or appropriately sized table references. Remove volatile or unnecessary references where possible.

Check add-ins and report a reproducible Excel crash
Use these checks if the crash persists, particularly when it occurs during Calculate Sheet.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets for an easier transition, though it does not fix crashes in Microsoft Excel.

Frequently Asked Questions
How do I update Excel for Mac?
In Excel, select Help > Check for Updates. If you installed Excel from the Mac App Store, open the App Store and check Updates.
Why split SORT and FILTER into separate formulas?
Putting FILTER in a helper cell and sorting its spill range lets you test each calculation independently. Enter FILTER in an empty cell, then reference its spill range, such as E2#, in SORT.
Can full-column references contribute to calculation problems?
Full-column references can make formulas evaluate more cells than necessary. In the formula bar, replace references such as A:A with bounded ranges or appropriately sized table references, then retest.
Does Excel for Mac have its own Safe Mode?
The test described here uses macOS Safe Mode, not an Excel-specific Safe Mode. Follow Apple's startup instructions for your Mac model, then open Excel and retest the worksheet.
Will WPS Office fix the crash in Excel?
No. WPS Office is an alternative for working with compatible Excel files; it does not repair Microsoft Excel. Check that your workbook's formulas and features behave as expected if you open it in WPS Spreadsheets.




