'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Crashing When Macros Generate Files
Question details
Excel for Mac abruptly crashes and returns an EXC_BAD_ACCESS error when running a VBA macro designed to generate files.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Running a macro that exports or generates files in Excel for Mac, typically right after a recent Office or macOS software update.
- Observed behavior
- The application crashes completely, interrupting the macro's file generation process, and displays an EXC_BAD_ACCESS error in the crash report.
Before beginning the troubleshooting process, copy the text from the Microsoft Error Reporting dialog (the crash log) and paste it into a text document, as you may need it if you contact support.
Verify the Mac Startup Volume with Disk Utility
Because the macro attempts to write files to your drive, ensuring your Mac's file system is healthy can resolve underlying EXC_BAD_ACCESS errors.
An EXC_BAD_ACCESS error often means the application attempted to access memory or storage in an unexpected way. Running First Aid checks the startup volume for formatting and directory structure errors.
Go to Finder, click on 'Applications', open the 'Utilities' folder, and double-click 'Disk Utility'.
In the left sidebar of Disk Utility, select your main Mac startup volume (usually named Macintosh HD).
Click the 'First Aid' button at the top of the window, then click 'Run' to allow your Mac to check and repair any detected file system errors.
Roll Back to a Previous Excel for Mac Build
If the crashes started immediately following a Microsoft Office update, reverting to an older Excel version can bypass the newly introduced bug.
Submit a Support Ticket with the Crash Report
If local troubleshooting fails, Microsoft Support can analyze your specific EXC_BAD_ACCESS crash log to identify the root cause.
Try WPS Office for Seamless and Stable Spreadsheet Editing
If Excel for Mac continues to crash or struggles with stability after system updates, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling your spreadsheets and daily office tasks without heavy system loads.
- 1. Download the Application: Visit the official WPS Office website and download the free macOS installer.
- 2. Install WPS Office: Open the downloaded file and follow the on-screen prompts to install the suite on your Mac.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks directly to continue your work seamlessly.
Frequently Asked Questions
What does an EXC_BAD_ACCESS error mean in Excel for Mac?
An EXC_BAD_ACCESS error indicates that Excel attempted to access a memory space it wasn't allowed to use. This is often caused by software bugs, corrupted application files, or conflicts between complex macros and the macOS file system.
Why do macros suddenly cause crashes after an update?
System or Office updates can alter how applications interact with the operating system's memory and storage. These changes can introduce compatibility issues with existing VBA code, especially code designed to generate, export, or save files.
How can I view the detailed Excel crash report on my Mac?
When Excel crashes, a Microsoft Error Reporting dialog usually appears on your screen. You can click the 'More Information' button in this dialog to view the detailed crash log, which includes the specific error type (like EXC_BAD_ACCESS) and thread information.
Will reinstalling the exact same version of Excel fix the macro crash?
Sometimes a clean install can fix corrupted app files. However, if the issue is a bug specifically introduced in that current build, reinstalling the same version will not resolve it. You will likely need to install a previous stable version or wait for an official patch.
