Fix Excel for Mac Crashing When Removing Duplicates in an XLS Workbook
Question details
The user needs to remove duplicate values from an XLS workbook without Excel becoming unresponsive or crashing.

- Product
- Microsoft Excel 2016 for Mac
- Device & OS
- macOS High Sierra
- Scenario
- Using Remove Duplicates on an Excel workbook saved in the older .xls format.
- Observed behavior
- Excel becomes unresponsive or crashes when Remove Duplicates is used.
Identify the affected .xls file and the columns used to determine duplicates. If Excel is unresponsive, use Apple menu > Force Quit to close it before reopening the workbook.
Update Excel and macOS, then convert the workbook to XLSX
Use this approach to rule out outdated software and the older XLS file format.
Open Apple menu > App Store > Updates and install any available macOS updates. Check compatibility before upgrading to a newer macOS release.
Open Excel and select Help > Check for Updates. Install any updates offered by Microsoft AutoUpdate for your Office version.
Open the affected workbook and choose File > Save As. Select Excel Workbook (.xlsx) as the format and save it under a new name; do not simply change the filename extension.
In the XLSX copy, select the relevant data range, choose Data > Remove Duplicates, and select the columns to check. Confirm that the resulting rows are correct.

Test a sample workbook and check third-party add-ins
Use this if the crash continues after updating and converting the workbook.
Work with spreadsheet duplicates in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for opening and editing Office files. It does not repair Excel, but it offers another way to work with your spreadsheet. Check that the WPS version you install supports your macOS version.

Frequently Asked Questions
Can I convert an XLS file to XLSX by renaming it?
No. Open the workbook in Excel and use File > Save As, then choose Excel Workbook (.xlsx). Renaming the extension alone does not convert the file.
What does Remove Duplicates delete?
Excel compares the columns you select in Data > Remove Duplicates and removes duplicate rows from the selected range. Select the full table when related columns need to stay together.
How can I tell whether the workbook is causing the crash?
Create a new workbook with a few duplicate values and run Data > Remove Duplicates. If the new workbook works but the original does not, the problem may be specific to the original file or its contents.
Where can I check for Excel updates on a Mac?
In Excel, select Help > Check for Updates to open Microsoft AutoUpdate. Install any updates offered for your Office version.
Will WPS Office fix the Excel crash?
No. WPS Office is an alternative spreadsheet application, not a repair for Excel. You can try opening the XLS or XLSX workbook in WPS after checking that its version supports your macOS release.




