Fix Excel for Mac Crashing When Running the Regression Tool
Question details
Excel for Mac crashes repeatedly when attempting to use the Regression tool within the Data Analysis ToolPak.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Running statistical regression analysis on various datasets using the Data Analysis ToolPak.
- Observed behavior
- The application suddenly crashes after selecting the input range and clicking OK, preventing the regression analysis from completing.
Ensure you have saved all open workbooks and fully closed Microsoft Excel before attempting to clear application cache files or troubleshoot system fonts.
Reset the Excel Application Container
Clearing potentially corrupted Excel cache files forces the application to rebuild its preferences and often resolves sudden crashes during specific tasks.
macOS isolates application data inside specific container folders. Removing the Excel container directory will clear temporary data and cached configurations that might be causing the Data Analysis ToolPak to fail.
Ensure Excel is completely closed. Right-click the Excel icon in your Dock and select 'Quit'.
Open Finder, click 'Go' in the top menu bar, hold down the 'Option' key on your keyboard, and click 'Library' when it appears in the dropdown.
Navigate to the 'Containers' folder and find the folder named 'com.microsoft.excel'.
Drag the 'com.microsoft.excel' folder to your desktop. This safely removes it from the active library so Excel can generate a fresh one.
Launch Excel again, open your dataset, and try running the Regression tool to see if the issue is resolved.

Test in Mac Safe Mode and Validate Fonts
Booting into Safe Mode isolates background processes, while validating fonts ensures that corrupted typefaces aren't crashing Excel's rendering engine.
Try WPS Office for Seamless and Stable Data Analysis on Mac
If Microsoft Excel continues to crash or requires tedious troubleshooting, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that supports complex spreadsheet functions and data analysis tasks natively on macOS without the stability issues.
- 1. Download the Mac client: Visit the official WPS Office website and download the installation package designed for macOS.
- 2. Install and launch: Complete the quick installation process and open WPS Spreadsheets.
- 3. Open your data: Load your existing .xlsx dataset directly into WPS Office with zero formatting loss.
- 4. Analyze seamlessly: Utilize the built-in data processing and statistical tools to complete your work without unexpected crashes.

Frequently Asked Questions
Why does Font Book affect Excel's Data Analysis ToolPak?
Excel relies on system fonts to render dialog boxes and output tables. If a font file is corrupted or duplicated, Excel may fail to render the regression analysis results interface, resulting in a sudden application crash.
Will removing the com.microsoft.excel folder delete my saved spreadsheets?
No, the Containers folder only stores application cache and temporary preference files. Your actual spreadsheets, workbooks, and saved documents stored locally or on OneDrive will not be affected.
Does the Regression tool require a specific add-in enabled on Mac?
Yes, to use the Regression tool, you must ensure the Analysis ToolPak is enabled. You can do this by going to Tools > Excel Add-ins in the top menu and checking the box for Analysis ToolPak.
Can updating macOS fix Excel crashes?
Yes, system updates often include critical bug fixes, memory management improvements, and font rendering patches that can resolve underlying application crashes experienced in Microsoft Office apps.




