Windows updates, you gotta love them! This October update has a lot of developers scratching their head.
Here at OneTwo, we became first aware of the problem when some clients called our support team with the same remark: “Exporting the data to Excel does not work!” After going through the usual procedure following the directions of Roy Trenneman from the IT crowd “have you tried turning it on and off again?“, we quickly became aware there was something more going on…
Indeed, Microsoft had rolled out a new update. “Drop everything, we have a KB hunt on our hands!” A time consuming thing to do, and in the meantime a lot of worried users. Google and the MSDN site had to do overtime too.
SEE UPDATE FURTHER FOR A MORE PERMANENT SOLUTION!
Quite some time later, we found the little buggers. Here is the list for anyone out there banging his head aginst the wall asking himself why his code, which has been running for years, suddenly stopped working:
- Windows 7: KB4041681
- Windows 8.1: KB40416393
- Windows 10: KB4040724/KB4041676
Uninstall them and reboot. Hooray, code is working again!
It looks like Windows keeps insisting to run the update. Here is a more permanent solution.
1. Find prior version (4.0.9801.0) of msexcl40.dll
2. Place in another directory. They suggest the application directory, but since in the next step you will modify registry to point to this older version, it can probably go anywhere.
3. Update registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel\win32 to point to the location from step 2.
You don’t even have to restart your PC.
Have a great weekend, my fellow IT minions!