Fix Excel for Mac Freezing When Searching a Large Workbook
Question details
The user needs Excel for Mac to search a large, multi-sheet workbook without freezing.

- 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.
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.
Test Excel for Mac after a safe startup
Use a safe startup to check whether software loaded at startup contributes to the freeze.
Choose Apple menu > Shut Down and wait for the Mac to turn off.
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.
Open Excel and the affected workbook, then search for the same term using the standard search box. Compare the result with a normal startup.
Choose Apple menu > Restart without holding any keys. If the search worked in safe mode, investigate login items and other background software.

Use Advanced Search as a workaround
Use this option to continue searching the workbook if Advanced Search works while the standard search box freezes.
Reinstall Office 2016 for Mac
Consider reinstalling if testing points to the Office installation and the freeze persists.
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.

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.




