Fix VBA ScreenUpdating Bug After Office Update
Question details
A VBA macro utilizing Application.ScreenUpdating fails to behave correctly when saving a newly created workbook following a recent Microsoft Office update.

- Product
- Microsoft Office
- Device & OS
- not provided
- Scenario
- Running a VBA macro that involves saving a new workbook while Application.ScreenUpdating is turned off to improve performance.
- Observed behavior
- The macro behaves unpredictably or visually stutters on updated computers (specifically suspected on Office Version 2312, build 17126.20132, Click-to-Run), but functions normally on environments that have not received the update.
Ensure you have administrative privileges on your computer, as you may need to apply software updates or roll back your Office installation to resolve this version-specific regression.
Verify Office Version and Apply Updates or Rollback
Check your specific Office build to confirm if you are on the affected version, then update to a patched version or roll back to a stable release.
Microsoft Office updates can occasionally introduce regressions in VBA functionality. This particular ScreenUpdating issue is heavily associated with Office Version 2312, build 17126.20132 (Click-to-Run). Comparing the exact version between working and non-working computers is the best way to isolate the issue.
Open any Office application, such as Excel. Navigate to File > Account > About Excel. Look for the version number, build number, and update channel (e.g., Click-to-Run).
If you are currently on the affected build (2312), check if Microsoft has released a patch. On the Account page, click 'Update Options' and select 'Update Now'.
If a newer update does not resolve the issue, consider using the Microsoft Office Deployment Tool to temporarily roll back to the previous stable build where the macro worked, and disable automatic updates until a permanent fix is released.

Implement Robust Error Handling to Restore ScreenUpdating
Modify your VBA macro's code to ensure that Application.ScreenUpdating is forcefully restored even if the save action interrupts the script's execution.
Try WPS Office for Stable VBA Macro Performance
If sudden Microsoft Office updates are disrupting your daily workflow with VBA regressions, consider switching to WPS Office. It provides a lightweight, highly compatible environment with excellent macro support, ensuring your VBA scripts run smoothly without unexpected update-related bugs.
- 1. Download and install: Get the latest version of WPS Office Free from the official website and complete the quick installation.
- 2. Open your macro-enabled workbook: Launch WPS Spreadsheet and open your existing .xlsm files directly.
- 3. Run macros smoothly: Enable macros when prompted and run your VBA scripts without worrying about version-specific regressions.

Frequently Asked Questions
Why does Application.ScreenUpdating stop working after a Microsoft Office update?
Office updates can sometimes contain unintended bugs or regressions that affect the VBA engine. Specifically, Office Version 2312 (Build 17126.20132) introduced a bug that disrupts the ScreenUpdating property when executing code that saves newly created workbooks.
How can I check my exact Office build number?
Open Excel, click on the File tab, select Account from the left menu, and look under the 'About Excel' section. You will see your current Version, Build number, and installation type (such as Click-to-Run).
Will rolling back my Office version delete my workbooks or macros?
No. Rolling back to a previous Office build using the Office Deployment Tool only affects the application software files. Your personal files, workbooks, and custom VBA macros will remain completely safe and untouched.
Does WPS Office support Microsoft Excel VBA macros?
Yes, WPS Office offers strong compatibility with Microsoft Office macro formats (.xlsm) and supports standard VBA scripting, making it an excellent, stable alternative for running your automated tasks.




