How to Fix Excel Freezing When Recording a Macro on Mac
Question details
The user experiences Excel becoming unresponsive or freezing while attempting to record a macro on a Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Recording a macro to automate repetitive tasks in a workbook.
- Observed behavior
- Excel freezes, crashes, or becomes completely unresponsive during the macro recording process.
Before modifying application preferences or disabling add-ins, save your current workbook and completely quit Microsoft Excel to ensure changes take effect properly.
Update Excel and Disable Conflicting Add-ins
Keeping Excel up to date and removing third-party interferences are the most common fixes for macro recording freezes.
Outdated software versions or problematic third-party add-ins are frequent culprits behind Excel crashes on macOS. Isolating the issue by testing a simple macro without add-ins can quickly restore functionality.
Go to Excel > Preferences > Security & Privacy in the top menu bar and ensure that macros are enabled.
Open Excel, click Help in the top menu bar, and select Check for Updates. Install any available software updates to ensure you have the latest bug fixes.
Navigate to Tools > Excel Add-ins. Uncheck all active add-ins and restart Excel to see if an add-in was causing the crash.
Open a new, blank workbook. Try recording a very basic action, such as selecting a cell and changing its font color. If it works, gradually increase the complexity.

Clear Excel Preference Files
Corrupted application preference files can cause Excel to freeze during advanced operations like macro recording.
Write the Macro in the VBA Editor Manually
If the macro recorder is broken but the VBA environment works, you can bypass the recorder by writing the VBA code directly.
Switch to WPS Office for a Smoother Spreadsheet Experience
If Microsoft Excel keeps crashing or freezing on your Mac, WPS Office provides a lightweight, highly compatible alternative. It natively supports Microsoft Excel formats and offers a stable environment for complex spreadsheet tasks.
- 1. Download WPS Office: Visit the official WPS Office website and download the free macOS installer.
- 2. Install and Launch: Follow the simple installation prompts and launch WPS Spreadsheet.
- 3. Open Excel Files: Drag and drop your existing Excel workbooks directly into WPS to continue working without interruptions.

Frequently Asked Questions
Why does Excel only freeze when I try to stop recording the macro?
This often happens if the recorded actions generated an excessively long loop or complex VBA code that Excel struggles to compile and save. Starting with a simpler macro can help diagnose this behavior.
Will I lose my existing macros if I delete the Excel preferences file on my Mac?
No, your macros are saved within your macro-enabled workbooks (.xlsm) or your Personal Macro Workbook, not in the macOS application preference (.plist) files.
Do third-party Mac clipboard managers conflict with Excel macro recording?
Yes, some clipboard managers or text-expansion utilities might interfere with Excel's ability to record keystrokes and copy-paste actions, leading to freezes. Try temporarily disabling them while recording.
How can I tell if an Excel add-in is causing the macro freeze?
You can launch Excel in Safe Mode by holding the Shift key while it opens, which disables add-ins. If the macro recorder works perfectly in Safe Mode, an add-in is the likely culprit.




