Forum Discussion
GRosenberg775
Jul 11, 2022Copper Contributor
Application.ScreenUpdating Freezing Workbook
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 coup...
wishicouldcode
Jul 13, 2022Copper Contributor
UPDATE TODAY - MS said an update came out that should fix this.
Steven_Jansen_DataB
Jul 13, 2022Copper Contributor
We are experiencing the same problems, has a huge impact on processes here.
We update to version 2206 (15330.20246) and rebooted, but it did not solve it.
Awaiting new update?
Steven
We update to version 2206 (15330.20246) and rebooted, but it did not solve it.
Awaiting new update?
Steven
- wishicouldcodeJul 13, 2022Copper Contributor
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
- tbird75Jul 15, 2022Copper Contributor
The following macro will cause all versions of the latest releases of Excel version 2206 to lock up, even the latest version 15330.20246
Sub Excel_Freeze()
ThisWorkbook.Application.ScreenUpdating = False
For Each Worksheet In ThisWorkbook.Worksheets
Next Worksheet
ThisWorkbook.Application.ScreenUpdating = True
End Sub
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.
- bimbamJul 21, 2022Copper ContributorSame issue.
Please fix this ASAP Microsoft (or, you know, make this default behavior to fix how terrible VBA performance is in general).