XP Operating system and Updates
Initially we have some extra points to consider for XP operating system
_a) …."The procedure entry point "GetDataFormEX" was not found in the DLL "KERNEL32.dll"….. Bollox !
Primarily , this Thread has been concerned with the breaking by Microsoft updates of ActiveX embedded in a worksheet controls in Excel 2003. During the course of the work some other problems were encountered whereby updates specifically caused problems with the XP operating system, ( http://www.eileenslounge.com/viewtopic.php?f=21&t=31405 m ). Amongst other things, the problems include completely disabling all Office. For convenience we will add the known problem causing updates to our “bad” list. So far these include
KB4461614
KB4461522
_b) No way to list Office Updates in XP
In this and associated Forum Threads we have made effective use of the software for from Nir Sofer
Unfortunately it appears that at this time the current version misses listing all Microsoft Office updates. I am not sure why this is. I have contacted and informed Nir Sofer of my observations.
It has therefore been necessary to manually add these to column A in the file for XP computer updates , “WMI Query XP.xls” ………_
_..............................................3 days later..
_.________________________________
Here are a couple of examples, (i) and (ii) at getting an XP machine working by removing “bad” updates
(i) LG X120 which I have had for a few years, and about 5 years ago added Excel 2010 and just recently added Excel 2003. ActiveX embedded in a worksheet controls in Excel 2003 have never worked ( Ident: Froggy)
Using the routine Sub UpOKs() to mark green the OK updates gives almost a manageable number of updates to check, especially as all results so far suggest we only need to look at updates associated with Microsoft Office. The full list is
Reducing this to just those associated withCode:KB979904 KB979904 KB977354V2 KB976749-IE8 KB958483 KB936929 KB925766 KB903157 KB900325 KB898458 KB888111WXPSP2 KB2964358-IE8 KB2936068-IE8 KB2925418-IE8 KB2909921-IE8 KB2909210-IE8 KB2904878 KB2904878 KB2898785-IE8 KB2888505-IE8 KB2879017-IE8 KB2846071-IE8 KB2838727-IE8 KB2834905_MCEUR2 KB2834905_MCEUR2 KB2834905-V2_MCEUR2 KB2834905-V2_MCEUR2 KB2833951 KB2833951 KB2742607 KB2742607 KB2723135-V2 KB2705219-V2 KB2698035 KB2698035 KB2656378 KB2656378 KB2628259 KB2619340 KB2604042 KB2604042 KB2502898 KB2280971 KB3054873 KB3213638 KB3085605 KB3085605 KB3085605 KB3085605 KB3115457 KB974554 KB943452 KB943873
A search for “Bads” revealed
KB3054873
KB974554
After de installing KB3054873, ActiveX embedded in a worksheet controls in Excel 2003 began working. No restart was necessary
I checked re installing and de installing a few times. Constantly ActiveX embedded in a worksheet controls in Excel 2003 were broken with the update installed, and by de installing they were working.
KB3054873 was one of 80*!# ( manually counted ) shown updates associated with Microsoft Office 2010. The de instillation appears just to have removed this single update, and ( manually ) counted are 79 shown updates associated with Microsoft Office 2010 after the de instillation.
*!# Note some updates are shown duplicated
I have left KB974554 ( which is shown as associated with Excel 2003 ) installed.
I have not removed KB974554 from the bad list yet. But also I have added it to the “good” list….
This machine was found to have the " The procedure entry point "GetDataFormEX" was not found in the DLL "KERNEL32.dll"" .....problem again around the 26th Jan 2019. The problem was removed on the problem on 27th Jan by removing an update not yet known as a problem update:
KB4462157
On the afternoon of 28th Jan 2019 , I noticed the computer getting updates as I tried to switch it off. I guessed that would mean trouble. Sure enough both problems were back by next power up. I investigated.. The following “bads” were found
3054873 – kills ActiveX embedded in a worksheet controls in Excel 2003
4462157 – " The procedure entry point "GetDataFormEX" was not found in the DLL "KERNEL32.dll"" .....problem
Unfortunately, mostly no date information is shown in the computers update list, but 4462157 was shown as the last .
Removing those updates cured both problems immediately without need for any restarting. A couple of other updates not yet had could be added to the “OK” list
As a temporary step I have disabled updates on the XP machines , as I need them for a while in a situation where curing bad updates may be difficult. ( Steps to do this are usually similar to the following:
Start.JPG : https://imgur.com/OOolPTM
System Steuerung Control Panel.JPG : https://imgur.com/pzocOwj
Automatic Updates.JPG : https://imgur.com/bzov1dH
Block Updates XP.jpg : https://imgur.com/6eajvnX , https://imgur.com/qSNW4Nh )
_._________
(ii) Another LG X120 XP Notebook (NichtFroggy)
A second older Notebook having had Office 2010 installed somewhat longer than the previous Notebook , but only just recently having Office 2003 installed. ActiveX embedded in a worksheet controls in Excel 2003 were found not to be working immediately after the instillation of Office 2003
It was quite easy to track down the problem with this final machine , as .._
_.. the use of routine Sub UpOKs() eliminated all but
KB2731847-V2
KB960763
KB3115284
KB3054873
and
_.. the use of Sub FindBads() revealed just one update as a potential problem
KB 3054873
De instillation of KB 3054873 resulted in immediate working of ActiveX embedded in a worksheet controls in Excel 2003
_..
On 26th Jan 2019 , I had to de instilliren the known problem update KB4461614 which suddenly appeared on this machine and caused the " The procedure entry point "GetDataFormEX" was not found in the DLL "KERNEL32.dll"" ......... problem as usual
The next day , 27th Jan 2019 the same problem was back, but this time the new update was found to cause the problem : KB 4462157
Also KB3054873 was back and had to be removed to remove the re apeard ActiveX worksheet embedded control problem
Feb14/15 2019 To assist here http://www.eileenslounge.com/viewtop...246560#p246527 I turned Updates back on.
All problems returned. I investigated.
Sub FindBads() Found only 3054873 and 974554 . Removing 3054873 cured the ActiveX embedded in a worksheet controls in Excel 2003.
Sub UpOKs() revealed “new updates”:
KB4462186
KB4100610
KB4108313
KB4462187
KB3115314
KB4462174
KB4462177
KB3054873
KB2597807
KB4462182
KB2760949
A report was made of 4462174 causing problems https://answers.microsoft.com/en-us/...1-f9543f1c19c0 Removing this has solved the problem in Office 2010 in XP
15/16th Feb2019
I watched the updating at around 3.00p.m. I had never done this before. A liitle pop up came up, saying it had a couple of updates, I clicked on it, then agreed to it updating 1 littlePopUp 2 ExpressUpdates.jpg : https://imgur.com/cMTvbrv , AgreeToUpdate.jpg : https://imgur.com/hv0VtPw It seemed to have updated, 3054873 killed the ActiveX embedded in a worksheet controls in Excel 2003, 4462174 killed XP.
Took them both out then all was OK again
15thFeb2019 Ident J
I have another LGX 120 that was hardly ever on the internet. It has had no problems and has hardly any updates J Start 2 SystemControl 3 Software 4 Updates : https://imgur.com/Gr2jwLW I checked its update settings https://imgur.com/33wuTGw
But the next day, nothing had changed.
_.______________
"WMI Query XP.xls" : https://app.box.com/s/5brcqrc5uk4tuhmwdgrr1dhygnmh7nr5
Here is an update specifically for the issue "updates killing Office 2010 in XP":
Update April 2019:
Here is a new recent “killer” update : KB4462223
Office 2010 in XP” killers”:
KB4461522 ( no longer available )
KB4461614 ( available , but not been offered for some time )
KB4462157 ( available , but not been offered for some time. ( Originally this was introduced to solve the problem. It never did. Quite the opposite, it causes the problem if you install it, just as all the other “killers do !!. ) )
KB4462174 ( available, and until recently, was still offered )
KB4462223 : The latest, available, and being currently offered
https://answers.microsoft.com/en-us/...1-0158c6327f48
https://answers.microsoft.com/en-us/...16500c3?page=5
http://www.eileenslounge.com/viewtop...249846#p249846
https://social.technet.microsoft.com...eitproprevious
The next post summarises the conclusions of this Thread.
Reply With Quote
Bookmarks