Fix Excel 2016 Crashes When Opening VBA or Inserting a Module
Question details
The user needs to stop Excel 2016 from crashing when opening the VBA editor or inserting a module.
- Product
- Microsoft Excel 2016
- Device & OS
- Windows 10
- Scenario
- The user wants to open Visual Basic or insert a VBA module in Excel.
- Observed behavior
- Excel crashes immediately when opening Visual Basic or inserting a module, even after Office repair and updates.
Close Excel before changing Windows settings or testing Safe Mode. Note whether the crash happens in every workbook and whether Office has already been updated and repaired.
Turn Off the Windows UTF-8 Beta System Locale
Check this Windows setting first if Excel crashes when you open or use the VBA editor.
Open Control Panel, select Region, and then select the Administrative tab.
Select Change system locale and clear the checkbox labeled Beta: Use Unicode UTF-8 for worldwide language support, if it is selected. Select OK.
Restart Windows, open Excel, press Alt+F11, and try Insert > Module in the Visual Basic editor.

Test Excel in Safe Mode and Disable Add-ins
Use Safe Mode to check whether an Excel or COM add-in is contributing to the crash.
Review the Office 32-bit or 64-bit Installation
Consider changing Office bitness if the locale and Safe Mode checks do not resolve the crash.
Work on Spreadsheets in WPS Office While Troubleshooting Excel
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open compatible spreadsheets in WPS while troubleshooting Excel; it does not repair Excel or guarantee compatibility with every VBA macro.

Frequently Asked Questions
Where do I find the UTF-8 system locale setting?
In Windows 10, open Control Panel > Region > Administrative > Change system locale. Clear Beta: Use Unicode UTF-8 for worldwide language support if it is selected, then restart Windows.
What does it mean if Excel still crashes in Safe Mode?
A crash after starting Excel with Windows+R > excel /safe makes an add-in less likely to be the cause. Check the Windows system locale and consider reviewing Office bitness and compatibility.
How can I check whether Excel 2016 is 32-bit or 64-bit?
Open Excel and select File > Account > About Excel. The version information identifies the installation as 32-bit or 64-bit.
Will switching from 64-bit to 32-bit Office fix the VBA crash?
It may help in some cases, but it is not guaranteed. Check your add-ins and VBA code for architecture requirements before uninstalling and reinstalling Office.




