How to Stop Excel Crashing When Removing Duplicates on Mac
Question details
The user needs to stop Microsoft Excel for Mac from unexpectedly quitting when using the Remove Duplicates feature and to identify whether a damaged workbook, Excel cache, outdated software, or profile conflict is responsible.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user is cleaning a dataset by removing duplicate rows in Excel on a Mac and the application closes unexpectedly.
- Observed behavior
- Excel crashes or quits without warning when the user selects Data > Remove Duplicates, especially in a specific workbook or across all files.
Before changing Excel settings, save and close any open workbooks, note whether the crash happens in one file or all files, and check for pending macOS and Office updates.
Update Excel and macOS Then Test a New Workbook
Use this first to determine whether the crash is caused by an outdated app or a damaged workbook before changing system files.
Save any open Excel files, then quit Excel from the Excel menu > Quit Excel.
Open the Mac App Store or use Help > Check for Updates in Excel, install all Microsoft Office updates, then restart Excel.
Go to Apple menu > System Settings > General > Software Update and install available macOS updates.
Open Excel, create a blank workbook, enter sample duplicate rows, select the range, and go to Data > Remove Duplicates to see whether it still crashes.
Reset the Excel Container Cache to Fix Remove Duplicates Crashes
Use this if Excel continues to close after updating or if the crash happens in one workbook; it clears a damaged com.microsoft.excel container cache.
Test in Safe Mode or a New macOS User Profile
Use this when the crash continues after a cache reset to identify conflicts from background apps or a corrupted user profile.
Switch to WPS Office for Stable Duplicate Removal on Mac
If Excel keeps crashing when you remove duplicates, WPS Office offers a free and lightweight Microsoft Office alternative on Mac. It opens .xlsx workbooks, keeps the familiar ribbon workflow, and lets you manage duplicate data without the same cache corruption issues.
Frequently Asked Questions
Why does Excel crash when I choose Remove Duplicates on Mac?
Excel can crash because of a damaged com.microsoft.excel container cache, an outdated version of Excel or macOS, a corrupt workbook, or interference from background applications and the user profile.
How do I reset the Excel cache on Mac to stop Remove Duplicates crashes?
Close all Office applications, open Finder > Go > Go to Folder, enter ~/Library/Containers, move the com.microsoft.excel folder to the Desktop, restart the Mac, and test Excel again.
Does Safe Mode help fix Excel crashing during Remove Duplicates?
Yes. Restart the Mac while holding the Shift key, open Excel in Safe Mode, and test Remove Duplicates. If the crash stops, a startup item or background app is likely causing the conflict.
Will WPS Office open my Excel file after Excel keeps crashing on Mac?
Yes. WPS Spreadsheets opens and saves Microsoft Excel .xlsx files, and you can remove duplicate values without relying on the damaged Excel cache.
