Fix Excel Crashing When Running the @RISK Add-in
Question details
The user needs to resolve an issue where Excel 2019 crashes unexpectedly when attempting to run the @RISK 8.2 add-in in a virtualized Windows environment.
- Product
- Microsoft Excel 2019 (64-bit) and @RISK 8.2 add-in
- Device & OS
- Windows 11 via Parallels on MacBook Air
- Scenario
- Running data analysis simulations using the @RISK add-in within a Windows 11 virtual machine on a Mac.
- Observed behavior
- Excel abruptly crashes and closes when the @RISK 8.2 add-in is executed, while other standard add-ins continue to function normally.
Ensure your Microsoft Office installation, Parallels Desktop software, and Windows 11 OS are updated to their latest versions to prevent common virtualization bugs.
Isolate the Add-in Compatibility Issue
Test Microsoft Excel with other built-in add-ins to determine if the crash is caused universally by Parallels or specifically by the @RISK software.
Running heavy third-party add-ins like @RISK in a virtualized Windows environment on ARM-based Macs can sometimes lead to software conflicts. Isolating the issue will help determine whether the fault lies with Excel's configuration or Palisade's software architecture.
Press the Windows key + R to open the Run dialog. Type 'excel /safe' and press Enter. This launches Excel without loading any third-party add-ins.
Navigate to File > Options > Add-ins. At the bottom of the window next to 'Manage', select 'COM Add-ins' from the dropdown and click 'Go'. Uncheck the @RISK add-in and click OK.
Return to the Add-ins menu (File > Options > Add-ins). Manage 'Excel Add-ins' and enable default tools like 'Analysis ToolPak' or 'Solver'. Run these tools to see if Excel remains stable.
If Excel works perfectly with default add-ins but crashes only when @RISK is enabled, the issue is highly specific to @RISK's compatibility with Windows 11 via Parallels. Contact Palisade technical support for dedicated patches, workarounds, or architecture-specific updates.
Try WPS Office for Seamless and Stable Spreadsheet Management
If you are experiencing persistent crashes and emulation issues with Microsoft Excel in virtualized environments, consider switching to WPS Office. It provides a lightweight, highly stable environment for your daily data analysis and spreadsheet tasks without overwhelming your system.
Frequently Asked Questions
Why does Excel crash when using COM add-ins in Parallels?
Virtualized environments like Parallels on newer Macs run the ARM version of Windows 11. Complex 64-bit COM add-ins designed strictly for x86/x64 architecture can experience memory faults during emulation, causing the host application (Excel) to crash.
How do I completely remove a faulty add-in from Excel?
Go to File > Options > Add-ins. Select 'COM Add-ins' in the Manage dropdown and click Go. Highlight the problematic add-in from the list and click the 'Remove' button, then restart Excel.
Can I run the @RISK add-in natively on a Mac?
No, the @RISK add-in is currently built exclusively for the Windows version of Microsoft Office. Mac users must rely on virtual environments like Parallels Desktop, VMware Fusion, or Boot Camp (for Intel-based Macs) to run the software.
