VBA & Macro Problems

Fix Excel VBA Macros Not Working After Version 2311 Update

Bushra Parveen Oct 9, 2026 869 views

Question details

Users report that previously working VBA macros and macro-enabled workbooks fail to run or save after updating Excel to Version 2311.

How to Fix VBA Problems After Excel Version 2311 Update

Product: Microsoft Excel
Device & OS: not provided
Scenario: Running or saving workbooks containing VBA macros after installing a recent Office update.
Observed behavior: VBA code completely stops running, fails to call other procedures, and prevents users from saving macro-enabled workbooks.

Before you start

Before modifying your Office installation or macro settings, ensure you save any open workbooks to a safe location and close all active Excel windows to prevent data loss during the rollback process.

Solution 1Recommended

Roll Back Excel to Version 2310

Reverting your Microsoft Office installation to the previous stable build (Version 2310, build 16924.20180) bypasses the bug introduced in the Version 2311 update.

This process uses the built-in Office Click-to-Run executable to downgrade your installation. You will need administrator privileges to complete these steps.

Open Command Prompt as Administrator

Click the Windows Start menu, type 'cmd', right-click on 'Command Prompt', and select 'Run as administrator'.

Navigate to the ClickToRun Directory

In the Command Prompt window, type 'cd %programfiles%\Common Files\Microsoft Shared\ClickToRun' and press Enter.

Execute the Rollback Command

Type 'officec2rclient.exe /update user updatetoversion=16.0.16924.20180' and press Enter. An Office update dialog will appear; wait for it to finish downloading and applying the older version.

Disable Automatic Updates

Open Excel, navigate to File > Account > Update Options, and select 'Disable Updates' to prevent Excel from automatically reinstalling the problematic Version 2311.

Temporary Solution: Keep automatic updates disabled until Microsoft releases a subsequent patch (after 2311) that explicitly resolves the VBA engine failures.

Solution 2

Configure Macro Security and Trusted Locations

Aggressive security settings can sometimes block VBA execution. Adding your workbook's folder as a trusted location ensures Excel does not block the macros.

Free Microsoft Office alternative

Try WPS Office for a Stable, Macro-Compatible Experience

If mandatory updates are constantly breaking your macros in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, free alternative with robust support for Excel file formats, high stability, and a familiar user interface for seamless migration without the headache of forced, disruptive updates.

1. Download and Install: Visit the official WPS Office website to download the free installer and follow the quick setup wizard.
2. Open Your Macro Workbook: Launch WPS Spreadsheet, click Open, and select your .xlsm file. Your data and layout will be preserved.
3. Work Without Interruptions: Continue editing and running your spreadsheet tasks in a stable environment that respects your workflow settings.

Highly compatible with Microsoft Excel formats including .xlsx and .xlsmStable performance without disruptive mandatory background updatesFamiliar user interface ensuring zero learning curveFree, lightweight, and fast-loading alternative to Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why did the Excel version 2311 update break my VBA code?

Software updates can occasionally introduce unforeseen bugs or conflicts within the VBA engine. In build 17029.20108 of Version 2311, an architectural change inadvertently caused macro execution and saving capabilities to fail.

How do I prevent Excel from automatically updating to version 2311 again?

You can stop automatic updates by opening Excel, navigating to File > Account, clicking on the 'Update Options' button next to Office Updates, and selecting 'Disable Updates' from the dropdown menu.

Can a code-signing certificate help run macros blocked by security updates?

Yes. If your macros are being blocked purely by security policies (and not a version bug), applying a code-signing certificate to your VBA project and adding it to the 'Trusted Publishers' list in the Trust Center can allow them to run seamlessly.

Will rolling back my Office version delete my files?

No, rolling back Microsoft Office using the Click-to-Run command only downgrades the application software itself. It does not affect, delete, or modify any of your personal files, workbooks, or data.

Excel & Data Problems