'%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 Charts Use Defined Names
Question details
The user experiences application crashes in Excel for Mac when working with charts that rely on formulas, defined names, or array formulas as dynamic data sources.
- Product
- Microsoft Excel
- Device & OS
- Mac / macOS
- Scenario
- Editing or updating complex workbooks where charts are dynamically linked to array formulas and defined names.
- Observed behavior
- Excel for Mac abruptly crashes during operation or calculation, which is likely caused by a software regression in recent application updates.
Before you begin troubleshooting, check your exact Excel version by opening Excel and selecting 'About Microsoft Excel' from the Mac menu bar to confirm if you are on an affected software build.
Downgrade or Update Your Excel Version
Since this crash is tied to a software regression in specific builds, reverting to an older stable build (like 16.84) or updating to a patched newer release (16.89.1 or later) is the most effective workaround.
Microsoft frequently updates Excel, and occasionally regressions are introduced that break complex formula handling. Rolling back to a previous version restores stability without requiring you to redesign your spreadsheets.
Navigate to your Mac's Applications folder, locate the 'Microsoft Excel' app, and rename it to something like 'Microsoft Excel Current' to preserve it as a backup.
Visit the official Microsoft Office for Mac update history webpage and download the installer package for version 16.84, or the latest available version like 16.89.1.
Run the downloaded installer. Once finished, open the newly installed version of Excel and test your charts with defined names to see if the crashing stops.
Simplify Chart Data Sources
If you cannot change your Excel installation, temporarily reducing the complexity of the formulas feeding your charts can prevent the application from crashing.
Report the Regression to Microsoft
Submitting your crash logs and file details helps the product team investigate and release a permanent patch for this specific regression.
Edit Complex Spreadsheets Without Crashing Using WPS Office
If Excel for Mac continues to crash due to software regressions with array formulas and dynamic charts, switching to a lightweight and highly compatible alternative can keep your work on track. WPS Spreadsheet handles complex defined names and data sources smoothly without unexpected crashes.
- 1. Download WPS Office: Get the free WPS Office installer for macOS from the official website and complete the quick installation.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file containing the dynamic charts and defined names.
- 3. Resume your work securely: Continue editing your formulas and updating your charts without experiencing the crashes associated with the Excel regression.
Frequently Asked Questions
What causes Excel for Mac to crash when using defined names in charts?
This issue is typically caused by a software regression in specific Excel updates where the calculation engine fails to correctly process complex array formulas or dynamic data sources linked directly to chart elements.
How can I keep my current Excel version while installing an older one?
You can have multiple Office versions installed on a Mac by navigating to your Applications folder and renaming the existing Microsoft Excel app (for example, to 'Excel Backup') before running the installer for the older version.
Will downgrading Excel for Mac affect my spreadsheet data?
No, downgrading to a slightly older version like 16.84 does not alter your workbook data. However, ensure that the older version you choose still supports any newer functions (like dynamic arrays) used within your spreadsheet.
