Office Apps Freezing

Fix Excel for Mac Freezing When Searching a Large Workbook

Maira MehtabMaira Mehtab Nov 22, 2026 868 views

Question details

The user needs Excel for Mac to search a large, multi-sheet workbook without freezing.

Fix Excel for Mac Freezing When Searching a Large Workbook
Product
Microsoft Excel for Mac 15.37
Device & OS
Mac; macOS 10.12.16 reported
Scenario
Searching a large workbook with the standard search box in Excel for Mac.
Observed behavior
Excel freezes without an error message. Advanced Search and searching the same workbook on a PC work normally; smaller workbooks also work correctly.
Before you start

Confirm whether the freeze occurs with the standard search box, Advanced Search, or both. Note your Excel and macOS versions and whether smaller workbooks search normally.

Solution 1Recommended

Test Excel for Mac after a safe startup

Use a safe startup to check whether software loaded at startup contributes to the freeze.

1
Shut down your Mac

Choose Apple menu > Shut Down and wait for the Mac to turn off.

2
Start in safe mode

On an Intel-based Mac, turn it on and immediately hold Shift until the login window appears. On an Apple silicon Mac, hold the power button until startup options appear, select the startup disk, hold Shift, and click Continue in Safe Mode.

3
Retest the search

Open Excel and the affected workbook, then search for the same term using the standard search box. Compare the result with a normal startup.

4
Return to normal startup

Choose Apple menu > Restart without holding any keys. If the search worked in safe mode, investigate login items and other background software.

Test Excel for Mac after a safe startup
If the freeze continues: A safe-mode test does not identify every possible conflict. Record the result and consider testing the Office installation next.
Free Microsoft Office alternative

Try WPS Spreadsheets for Workbook Searches

WPS Office is a free, lightweight, easy-to-use alternative with a familiar interface for working with spreadsheets. It supports common Excel formats, making it easier to move existing workbooks to WPS; it does not repair Excel for Mac.

Search spreadsheet workbooks in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for easier migrationWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel freeze only when I search this large workbook?

The cause is not established. Because smaller workbooks and Advanced Search work, test the affected file after a safe startup and compare the result with a normal startup.

Can I search the workbook while troubleshooting?

Yes. Open Advanced Search in the workbook, enter your search term, and select the workbook-wide search option if needed.

What should I do if safe mode makes no difference?

If testing points to the Office installation, follow Microsoft's instructions to remove and reinstall Office 2016 for Mac. If the freeze continues, share the workbook and system details through a private support channel.

Will WPS Office fix Excel for Mac?

No. WPS Office is a separate alternative, not a repair for Excel. You can open a compatible XLS or XLSX workbook in WPS Spreadsheets and try searching it there.