Fix Excel VBA and ActiveX Problems After a Microsoft 365 Update
Question details
The user needs to restore the functionality of Excel VBA projects, macros, and ActiveX controls that have broken or behaved abnormally following a recent Microsoft 365 software update.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use Excel files containing custom VBA macros, ActiveX buttons, or specific worksheet references immediately after applying a Microsoft 365 office update.
- Observed behavior
- ActiveX buttons stop responding to clicks, worksheet code names are unexpectedly renamed, and duplicate worksheet objects appear erroneously in the VBA project.
Before applying system-level fixes, check Microsoft's official release health dashboard for known Excel issues and consult your organization's IT department to ensure compliance with company policies.
Roll Back the Microsoft Office Update
Temporarily revert your Microsoft 365 installation to an earlier, stable build before the problematic update was applied.
Uninstalling the most recent Office update is often the safest and most reliable way to restore VBA and ActiveX functionality while waiting for Microsoft to release an official, permanent patch.
Open Excel, navigate to File > Account, click on the 'Update Options' dropdown under Product Information, and select 'Disable Updates' to prevent Office from immediately reinstalling the broken version.
Press the Windows key, type 'cmd', right-click Command Prompt, and select 'Run as administrator'. Enter the standard Office Deployment Tool rollback command for your specific previous version build number and press Enter.
Once the rollback process completes, restart your computer, open your affected Excel workbook, and test the VBA macros and ActiveX buttons to confirm they are functioning correctly.
Apply the ForceVBALoadFromSource Registry Workaround
Add a specific registry key to force Excel to load VBA from the source, resolving corruption caused by recent updates.
Try WPS Office for Stable Spreadsheet Management
Tired of unexpected update errors breaking your macros and controls? WPS Office provides a free, lightweight, and incredibly stable alternative for your spreadsheet needs with extensive compatibility for Microsoft Office formats, a familiar user interface, and zero forced updates that break your workflow.
- 1. Download WPS Office: Visit the official WPS website and download the free software installer for your operating system.
- 2. Install the Software: Run the downloaded installer file and follow the quick setup wizard to install the suite on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm files directly without any complicated conversion steps.
Frequently Asked Questions
Why do ActiveX controls suddenly stop working in Excel?
ActiveX controls can become unresponsive after specific Microsoft Office updates due to temporary system bugs, backend security patches that restrict control behavior, or corrupted temporary .exd cached files stored in your local user profile.
Can deleting temporary .exd files fix my ActiveX issues?
Yes, deleting the cached .exd files located in the %appdata%\Microsoft\Forms folder is a common troubleshooting step. This action forces Excel to rebuild the ActiveX controls cleanly upon the next launch, which frequently resolves display and interaction issues.
Is it safe to modify the Windows Registry to fix Excel problems?
Modifying the registry is inherently risky and should only be done if you are comfortable with advanced system troubleshooting. Always export a backup of the registry before making changes, or consult your IT department if you are on an enterprise device.
