Office Apps Crashing

Fix Excel for Mac Crashing with SORT and FILTER Formulas

Rana GarciaRana Garcia Nov 18, 2026 869 views

Question details

The user needs to prevent Excel for Mac from crashing when a worksheet calculates nested SORT and FILTER formulas.

Fix Excel for Mac Crashing with 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.
Before you start

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.

Solution 1Recommended

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.

1
Update Excel

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.

2
Test a new workbook

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.

3
Separate the formulas

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.

4
Limit referenced ranges

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.

Update Excel and simplify the SORT and FILTER formula
Leave room for results: FILTER and SORT return spilled arrays. Keep the cells needed for each result empty, and adjust the example ranges and criteria to match your workbook.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet data and formulas in WPS SpreadsheetsUse a familiar interface when moving from Microsoft OfficeGet a free, lightweight office suite
microsoft office alternative - wps office

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.