Office for Mac Issues

Fix Excel for Mac Crashing When Removing Duplicates in an XLS Workbook

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 870 views

Question details

The user needs to remove duplicate values from an XLS workbook without Excel becoming unresponsive or crashing.

Fix Excel for Mac Crashing When Removing Duplicates in an XLS Workbook
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.
Before you start

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.

Solution 1Recommended

Update Excel and macOS, then convert the workbook to XLSX

Use this approach to rule out outdated software and the older XLS file format.

1
Check for macOS updates

Open Apple menu > App Store > Updates and install any available macOS updates. Check compatibility before upgrading to a newer macOS release.

2
Update Office

Open Excel and select Help > Check for Updates. Install any updates offered by Microsoft AutoUpdate for your Office version.

3
Save an XLSX copy

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.

4
Test Remove Duplicates

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.

Update Excel and macOS, then convert the workbook to XLSX
Check version support: Office 2016 for Mac and macOS High Sierra are no longer supported. Available updates and compatibility with newer macOS versions may be limited.
Free Microsoft Office alternative

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.

Use spreadsheet tools to identify and remove duplicate data.Open and edit Microsoft Excel XLS and XLSX files.Navigate a familiar interface when moving from Microsoft Office.Use a free, lightweight office suite for everyday spreadsheet work.
microsoft office alternative - wps office

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.