Forum Discussion

Copper Contributor

Jul 11, 2022

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...

Copper Contributor

Jul 13, 2022

UPDATE TODAY - MS said an update came out that should fix this.

Steven_Jansen_DataB

Copper Contributor

Jul 13, 2022

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

wishicouldcode
Copper Contributor
Jul 13, 2022
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
- tbird75
  Copper Contributor
  Jul 15, 2022
  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.
  - bimbam
    Copper Contributor
    Jul 21, 2022
    Same issue.
    
    Please fix this ASAP Microsoft (or, you know, make this default behavior to fix how terrible VBA performance is in general).

Resources