Jul 11 2022 09:32 AM
Jul 11 2022 09:32 AM
Due to a recent update with Office 365, the Application.ScreenUpdating function in VBA does not work anymore (at least in Excel). I have a macro enabled workbook that has had the same code for a couple of years now. Each one of my subs have Application.ScreenUpdating = False at the beginning and Application.ScreenUpdating = True at the end. This has worked great for preventing Excel to work harder than it needs. The spreadsheet was worked on (not the VBA code) on Friday, and on Monday, the spreadsheet started freezing like the screen would not update no matter what I clicked on. I was eventually able to diagnose that if I removed all of the Application.ScreenUpdating = False, then the freezing no longer occurs. Again, the code has not changed in several months (and never for the ScreenUpdating portion) and has worked perfectly up until today. Has anyone else experienced a similar issue with the Applicaiton.ScreenUpdating function?
Jul 11 2022 06:36 PM
Jul 12 2022 06:57 AM - edited Jul 13 2022 04:00 AM
I am having the same issue. trying to report to Microsoft. we have to all keep doing this until they see the problem. Make sure to contact them through the help app until the issue is fixed.
Jul 12 2022 02:07 PM - edited Jul 13 2022 04:07 AM
Yep me too. Exact same issue.
Just created an empty xlsm with a macro with only
Application.ScreenUpdating = false
Application.ScreenUpdating = true
easy to reproduce.
Excel workbooks needs to be closed and opened again to get normal functioning.
Just updated to version 2206 build 15330.20246
Edited my post once more....After a full restart I found out today that the excel sheets work again! So for me, going to file -->account-->update options-->update now seems to have worked.
Jul 12 2022 03:25 PM
Jul 13 2022 02:41 AM - edited Jul 13 2022 05:00 AM
Same issue, for me and others in my workplace. Since we issue macros extensively to run functions for less Excel savy depts this is a real issue.
Update - Updating to new version - 2206 (15330.20246) seems to have resolved this for me.
Jul 13 2022 03:37 AM
Jul 13 2022 06:28 AM
Jul 13 2022 06:38 AM - edited Jul 13 2022 06:45 AM
Did you update windows?
you should contact MS help app and let them know. I havnt seen the issue yet but if I do I will be telling them right away
Jul 15 2022 09:53 AM
The following macro will cause all versions of the latest releases of Excel version 2206 to lock up, even the latest version 15330.20246
ThisWorkbook.Application.ScreenUpdating = False
For Each Worksheet In ThisWorkbook.Worksheets
ThisWorkbook.Application.ScreenUpdating = True
This runs successfully in all prior versions of Excel. We use a similar macro to size our multi-tab business worksheets to maximize screen size. They are all not running now. The issue appears to be turning screenupdating off while iterating the spreadsheet tabs in a multiple tab spreadsheet. Commenting out the first line will stop the problem.
But I believe this to be a bigger problem in this release than just this issue.
Jul 20 2022 10:06 PM