The error “Application.ScreenUpdating = true does not update screen” is a problem that you can find when you are doing some dataloading on excel and trying to turn screen updating. Given below is the snippet of the code used to turn on screen updating:
Application.ScreenUpdating = True
I would like to share with you the steps I took to fix the problem, “Application.ScreenUpdating = true does not update screen” in your project file.
Why Application.ScreenUpdating = true Excel does not update screen problem is seen?
The problem, “Application.ScreenUpdating = true does not update screen: in Excel is basically seen because you are using a 32 bit version of excel in your 32 bit computers.
This is a known problem to the Microsoft team and you can’t do something here except to wait till the excel team fix the error.
The detailed solution to fix the problem “Application.ScreenUpdating = true does not update screen”, is given below:
How to fix the error, Application.ScreenUpdating = true Excel does not update screen?
To fix the error Application.ScreenUpdating = true does not update screen in Excel, you either have to use a 64 bit version of excel in your 64 bit computer or make sure to use the latest compatible version which doesn’t have the issue.
To fix the problem, “Application.ScreenUpdating = true does not update screen”, you will have to follow the below mentioned steps:
This is a know error, if you are using a 32 bit version of excel in your 32 bit computers. The error is also seen in the product version 206 16.0.15330.20230.
So to fix the error you will have use a 64 bit version of excel in your 64 bit computer and make sure to use version 2206 16.0.15330.20216 .
If are still facing the same problem and you have updated your version to 64 bit, then you will to restart your system. This is the simplest fix so far and will sometimes will fix the error even if you are using the 32 bit version.
This is a problem from the Microsoft’s team in the 32 bit and we have to wait for the Microsoft’s team to fix it in the 32 bit version.
This should fix the error, “Application.ScreenUpdating = true does not update screen”.
Conclusion
To fix the error “Application.ScreenUpdating = true does not update screen” in Excel, you either have to use a 64 bit version of excel in your 64 bit computer or make sure to use the latest compatible version which doesn’t have the issue.