Forum Discussion
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...
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.
- I just tried a manual update from: Account -> Update options -> Update now.
This updated my Excel to v 2206 build 15330.20246, but now it looks like the screen updating functions are working fine? I tried my xlsm workbooks and none of them are freezing anymore.
Not sure what is happening as the update is the same version as yours.- I edited my post. Indeed after the update and a reboot it works again.
- maybe you can go to Microsoft help and let them know to tell developers to fix this
