I moved on to my computers with Vista operating system.
Vista ( Acer Aspire 4810TZG )
This computer has had office 2007 installed from new for over 10 years. It has been almost constantly connected to the internet. For a few years it has also had Office 2003 installed. ActiveX embedded in a worksheet controls in Excel 2003 have never worked.
The single culprit was found to be KB 2965286 , Update für Microsoft Office 2007 suites , , Microsoft hat ein Update für Microsoft Office 2007 suites veröffentlicht. Dieses Update stellt die neuesten Fixes für Microsoft Office 2007 suites bereit. Darüber hinaus enthält das Update Verbesserungen an Sicherheit und Stabilität. / Microsoft has released an update for Microsoft Office 2007 suites. This update provides the latest fixes for Microsoft Office 2007 suites. In addition, the update includes security and stability improvements Installed date was shown as 16th Nov 2016 in the Computers list update list, and 15th July 2015 in the Wul List
I had to close Excel to de install this.
The success with this allowed a large amount of updates to be added to the “good update” list
Vista ( Acer Aspire 7535G )
A similar machine to the previous, slightly less time in use as the previous, but with over 2000 updates, the most “updated” of my Computers. From new it has had Office 2010 installed. For a few years it has also had Office 2003 installed. ActiveX embedded in a worksheet controls in Excel 2003 have never worked.
From my list of “bad updates”, the following were present
KB2553154 Security Update for Microsoft Office 2010 32-bit edition , 10th December 2014 on Wul Microsoft Office 2010 32-bit Edition contains a vulnerability that could allow the execution of arbitrary code when a malicious file is killed. This security risk is addressed with this update. There is a security risk that could allow the execution of arbitrary code after opening a maliciously crafted file. The risk is resolved with this update. In Microsoft Office 2010 32-bit Edition Besteht ein Sicherheitsrisiko, das nach dem Öffnen einer in böswilliger Absicht veränderten Datei die Ausführung von beliebigem Code ermöglichen kann. Das Risiko wird mit diesem Update behoben.
KB2965291 Update Microsoft Office 2010 (KB2965291) 32-bit edition , 13th May 2015 on Wul , Microsoft has released an update for Microsoft Office 2010 32-bit Edition. This update provides the latest fixes for the Microsoft Office 2010 32-bit edition. In addition, the update includes improvements in stability and performance.
KB2920813 Update Microsoft Office 2010 32-bit edition, installed 12th March 2015 in Wul list , ( finally shown as the date of removal just before removal in the computer update list !?! ) . Microsoft has released an update for Microsoft Office 2010 32-bit Edition. This update provides the latest fixes for the Microsoft Office 2010 32-bit edition. In addition, the update includes improvements in stability and performance.
KB3054873 Update for Microsoft Office 2010 32-Bit-Edition, 12th March 2019 on Wul list . ( Shown as 24th December 2016 on the computers update list ) Microsoft has released an update for Microsoft Office 2010 32-bit Edition. This update provides the latest fixes for the Microsoft Office 2010 32-bit edition. In addition, the update includes improvements in stability and performance.
Based on a bit of intuitive guess work I decided to delete them in this order, and only after the last de instillation was success..!!. All the ( 3 ) successful de instillations required a computer restart. All 3 warned that other updates might be removed also. This may have happened **
KB3054873 The de instillation forced a restart of the computer
KB2965291 The de instillation forced a restart of the computer ### Note at this point it was indicated that there were 779 updates.
KB2553154 No de instillation was possible. This update was already gone **
KB2920813 The de instillation forced a restart of the computer ### Note at this point it was still indicated that there were 779 updates.
!! At this point, after the restart of the computer and Excel 2003, ActiveX embedded in a worksheet controls in Excel 2003 were working
I did some extra experiments …_
_.. I re installed KB3054873. It showed up as expected in the computers update list : KB3054873Back.JPG https://imgur.com/HONIwHs (### strangely again it was indicated that there were 779 updates, even after a computer restart : KB3054873 Back.JPG https://imgur.com/doRF6QI )
ActiveX embedded in a worksheet controls in Excel 2003 were broken
I de installed , ActiveX embedded in a worksheet controls in Excel 2003 were working again
I repeated the above a few times. Despite restarts etc., the displayed number of updates never changed.
The date shown in the Wul list remains at the original 23th July, 2015 changes, whilst the current date is shown in the computers update list.
Without the restart after a de instillation, the ActiveX embedded in a worksheet controls in Excel 2003 are not working. However if Excel is not open at the time of the de installation then no restart is asked for or is required and ActiveX embedded in a worksheet controls in Excel 2003 at the start of Excel
_.. I re installed KB2965291. It seemed to work, and ActiveX embedded in a worksheet controls in Excel 2003 stopped working. But it did not show up as expected in the computers update list.
Further investigation showed that KB3054873 had been re installed!!.
Removing KB3054873 and all is well again.
_.. I re installed KB2553154. It seemed to work. But it did not show up on the computers update list. ActiveX embedded in a worksheet controls in Excel 2003 were still working.
At this stage I did a quick check of the original Wul list and the current Wul list. I checked both KB number from column A and the Installation Date from column D. There was no difference
_.. I re installed KB2920813. It showed up as expected in the computers update list
ActiveX embedded in a worksheet controls in Excel 2003 were broken
I de installed , ActiveX embedded in a worksheet controls in Excel 2003 were working again.
The conclusions here are that these are “bad” news..
KB3054873
KB2920813
Possibly these are also „bad“:
KB2553154
KB2965291
_.___________________________
The success with this Notebook, allowed a large number of “good updates” to be added to my “OK list”.
As previously after finishing a “computer update repair” the entire list of original updates for this computer was added in a column of workbook “UpdatesOK.xls” , and then the ( 4 in this case ) “bad updates” removed , before running code Sub UpdatesOK(). The list produced by that is then copied to the worksheet “UpOK” in the file for the ( Vista in this case ) computers . This allows the code Sub UpOKs() in this file to be used to mark all the ( probably ) OK updates in the last Vista computer under investigation in the next section.
Vista ACER X3200
This computer has a similar history to the previous two Vista machines, except that it had long periods of no use. It has had Office 2007 from new, and in the last year Office 2003 was added. ActiveX embedded in a worksheet controls in Excel 2003 have never worked.
The list of not yet checked updates at the start of experimenting with this computer looks like this
It is almost a manageable number of updates to check through …Code:KB2804527 KB2754296 KB2478657 KB2478659 KB2510581 KB2518863 KB2518865 KB2544521 KB2596744 KB2596786 KB2596857 KB2596917 KB2597161 KB2597972 KB2687307 KB2687315 KB2687441 KB2687493 KB2760415 KB2760421 KB2817330 KB2827324 KB2827330 KB2881069 KB2899527 KB2899580 KB2920788 KB2920793 KB2920794 KB2920795 KB2956099 KB2956103 KB2956109 KB2965286 KB2984942 KB3118304 KB3127888 KB3127945 KB3141529 KB3141535 KB3178676 KB3178677 KB3178682 KB3178683 KB3191827 KB3191828 KB3191829 KB3191830 KB3191835 KB3191836 KB3191837 KB3191894 KB3191895 KB3191897 KB3203436 KB3203438 KB3203441 KB3213640 KB4011062 KB4011063 KB4011064 KB4013867 KB4017094 KB940157 KB952709 KB955302 KB956250 KB957200 KB970158 KB975558 KB982799
But not quite. Running the macro routine Sub FindBads() on the worksheet for this computer reveals just one,
KB2965286
Removing of this alone unfortunately did not solve the problem :-(
It did , however, narrow down a bit the updates to be checked as it apparently removed the following.. ( or maybe my Wul list was in error and they were not there.. )
KB2596744
KB2687441
KB2760415
KB2817330
KB2881069
KB3118304
KB3141529
KB3141535
KB3191837
KB3191895
KB3203436
KB3213640
At this stage the computers update list was still showing 192, as it had initially before attempting to remove any updates.
Removing KB2920794 solved the problem: ActiveX embedded in a worksheet controls in Excel 2003 began working immediately after removing this update, and before any restart.
I experimented a bit with the list of those apparently removed updates.
The following were available in the Microsoft catalogue ( https://www.catalog.update.microsoft.com ), they appeared to install , but were not to be found in the computers update list. (ActiveX embedded in a worksheet controls in Excel 2003 remained working, and the update list was always showing 192 )
KB2596744
KB2687441
KB2817330
KB3118304
KB3141535
KB3191837
KB3203436
KB3213640
The following were not to be found in the Microsoft catalogue
KB2760415
KB2881069
KB3141529
KB3191895
I concentrated on these two
KB2920794
KB2965286
Re installing those killed ActiveX embedded in a worksheet controls in Excel 2003, and de installing them brought them back into life.
So as a conclusion of this section, we have one more, KB2920794 , definitely to add to our list of “Bads()”
I am not sure whether these should be also added..
KB2596744
KB2687441
KB2817330
KB3118304
KB3141535
KB3191837
KB3203436
KB3213640
I expect in previous experiments other updates may have been removed, but I don’t know of any way yet to get a reliable controlled way to monitor the situation of updates automatically. Doing it manually does not seem to be something any sane person would do. I will report back and update after I have done this thoroughly some time in the future, possibly in another reincarnation.
For now, at this stage, all but KB2920794 and KB2965286 will be added to the “OK update” list, in preparation for the next phase, which is considering the XP operating system
Reply With Quote
Bookmarks