Fix Excel for Mac Freezing When Duplicating Sheets or Adding Rows
Question details
The user experiences freezing or crashing in Excel for Mac when attempting to duplicate worksheets or insert new rows.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Duplicating worksheets or inserting rows into an existing spreadsheet.
- Observed behavior
- Excel becomes unresponsive or crashes entirely, often generating a SIG_HANG_QUIT report that references OfficeArt and Microsoft Error Reporting.
Save any other open documents and manually back up your current Excel file to an external drive or cloud storage to prevent data loss during troubleshooting.
Update Software and Boot into macOS Safe Mode
Ensure your system and applications have the latest bug fixes, and use Safe Mode to rule out background app interference.
Running outdated software is a common cause of unexpected application crashes. macOS Safe Mode helps identify if background processes or conflicting software are causing Excel to freeze during heavy operations like sheet duplication.
Go to the Apple Menu > System Settings > General > Software Update to install any pending system updates.
Open Excel, navigate to Help > Check for Updates in the top menu bar, and install available Microsoft Office updates.
Restart your Mac and press and hold the Shift key immediately as it boots up to enter Safe Mode.
Open the problematic Excel file while in Safe Mode and attempt to duplicate a sheet or insert rows to see if the freeze still occurs.
Temporarily Disable Microsoft Error Reporting (MERP)
While this does not resolve the root cause of the crash, disabling MERP can sometimes bypass the hanging loop associated with the SIG_HANG_QUIT error.
Switch to WPS Office for a Stable Spreadsheet Experience
If Excel for Mac continues to freeze or crash, consider switching to WPS Office. It offers a lightweight, highly stable spreadsheet environment that handles large data operations smoothly while maintaining seamless compatibility with your existing workbooks.
- 1. Install WPS Office for Mac: Download and install the free WPS Office suite for your macOS device.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing Excel file directly.
- 3. Work Smoothly: Duplicate sheets and add rows effortlessly without experiencing application crashes.
Frequently Asked Questions
Why does Excel for Mac crash specifically when duplicating a sheet?
This typically occurs due to corrupted formatting, hidden objects, or complex OfficeArt elements within the sheet that overwhelm the application's memory allocation during the duplication process.
What does a SIG_HANG_QUIT error mean on a Mac?
A SIG_HANG_QUIT error indicates that an application stopped responding to the macOS operating system (a 'hang') and was forced to quit. In Excel, it usually points to an internal process loop or component failure.
Will reinstalling Microsoft Office fix the freezing issue?
Reinstalling can help if the application files themselves are corrupted. It is recommended to completely uninstall the suite using the official removal process before reinstalling to ensure all problematic background files are cleared.
