Fix Excel Crashing When Opening Macro Workbooks on M1 Mac
Question details
The user experiences unexpected application crashes in Microsoft Excel when attempting to open macro-enabled workbooks on an Apple M1 Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS (Apple M1 processor)
- Scenario
- Opening VBA macro-enabled workbooks on an Apple Silicon device.
- Observed behavior
- Microsoft Excel abruptly crashes and closes when the user attempts to load a workbook containing macros.
Ensure your macOS and Microsoft Office applications are updated to the latest versions, and temporarily save a backup copy of your macro-enabled workbook before modifying any application settings.
Enable 'Open using Rosetta' Compatibility Mode
Use Apple's built-in Rosetta 2 translation environment to run Excel, which resolves underlying architecture compatibility issues with older VBA components on Apple silicon.
Apple Silicon (M1/M2) processors use a different architecture than older Intel Macs. Because some legacy Visual Basic for Applications (VBA) components are not fully optimized for Apple Silicon natively, they can force Excel to crash. Enabling Rosetta forces the app to run in an Intel-compatible mode.
Open Finder on your Mac and navigate to the 'Applications' folder.
Find the 'Microsoft Excel' application icon, right-click (or Control-click) on it, and select 'Get Info' from the context menu.
In the Info window, look for the 'General' section and check the box next to 'Open using Rosetta'.
Close the Info window and relaunch Microsoft Excel. Try opening your macro-enabled workbook again to verify if the crash is resolved.
Clear Excel Container Cache and Test for Isolation
Remove potentially corrupted application cache files and verify if the crash is caused by a specific corrupted workbook rather than the application itself.
Try WPS Office for Your Spreadsheet Needs
If Microsoft Excel continues to struggle with crashes or performance issues on your Mac, consider switching to WPS Office. It provides a highly compatible, lightweight, and smooth spreadsheet experience tailored for modern macOS environments.
- 1. Download the Installer: Visit the official WPS Office website and download the Mac version.
- 2. Install on macOS: Open the downloaded .dmg file and drag the WPS Office icon to your Applications folder.
- 3. Open Your Spreadsheets: Launch WPS Office and directly open your existing Excel workbooks with seamless compatibility.
Frequently Asked Questions
Why does Excel crash specifically on my M1 Mac when using macros?
Apple Silicon (M1/M2) Macs operate on an ARM-based architecture, which is different from older Intel Macs. Some older Visual Basic for Applications (VBA) libraries embedded in Excel macros are not fully optimized for this architecture, leading to unexpected crashes unless run through a translation layer.
What is Rosetta and is it safe to use for Microsoft Excel?
Rosetta 2 is Apple's built-in translation environment designed to allow applications built for Intel processors to run seamlessly on Apple Silicon. It is completely safe, officially supported by Apple, and specifically designed to resolve these types of legacy software compatibility issues.
Will enabling Rosetta slow down my Excel performance?
While Rosetta translates the software code on the fly, Apple Silicon chips are exceptionally powerful. Most users will not experience any noticeable performance drop during standard spreadsheet usage, though exceptionally heavy macro calculations might take slightly longer.
How can I tell if my macro workbook is corrupted instead of it being an M1 compatibility issue?
To isolate the issue, create a brand-new workbook, add a simple macro, save it as a macro-enabled workbook (.xlsm), and attempt to open it. If the newly created file opens without crashing, it indicates that your application works fine and your original workbook is likely corrupted or contains incompatible legacy VBA code.
