I started with Windows 7
Win 7 64 Bit Professional
A computer with Win 7 64 Bit Professional, alive since approximately start of 2018, with Office 2003 and Office 2010 installed. ActiveX embedded in a worksheet controls had never worked in Excel 2003, ( no problem in Excel 2010 )
Running Sub FindBads() with the worksheet active containing the update list for this computer , " MartinJan2019Init " revealed the update KB3054873 as present.
Immediately after the removal , and before a restart, the ActiveX embedded in a worksheet controls in Excel 2003 started working. :-) It was not necessary to even close Excel
On the Computer system control it was shown as installed 10.01.2019 ( 10th January, 2019 ). On the list from a Windows Update List software ( https://www.nirsoft.net/utils/wul.html , https://www.eileenslounge.com/viewto...=31572#p244479 , http://www.excelfox.com/forum/showth...0893#post10893 , https://app.box.com/s/wm3qcgy5gn4csq0csuk5fp2iqu0hrqxz ) it was shown as installed on 22.02.2018 ( 22nd February, 2018 )
This is described as Update für Microsoft Office 2010 (KB3054873) 32-Bit-Edition, Microsoft has released an update to the 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.
KB3054873Download.JPG : https://imgur.com/BgcPwV0
https://www.catalog.update.microsoft...px?q=KB3054873
Update für Microsoft Office 2010 (KB3054873) 64-Bit-Edition Office 2010 Wichtige Updates 14.07.2015
https://www.catalog.update.microsoft...e-95a9689e721a
I tried to reinstall this to see what that effect would have,
DownloadKB3054873 19Jan2019.JPG : https://imgur.com/jq4wBpK
but it was not allowed:
Install KB3054873 19Jan2019 Not allowed.JPG : https://imgur.com/jq4wBpK
( The steps in a reinstall are not obvious . Here is another ( failed in this case also ) attempt on another machine to install KB3054873. This machine was a new machine with Office 2003 only installed.
Select to download ( Step 1 ) : This should cause a window to pop up. In this window, usually there is just one link to click on ( step 2 ) to download.
KB3054873 Download an 32Bit Win7 Home 1 2.JPG : https://imgur.com/WJevaIi
( Occasionally you may be unlucky and will have a list of links. For each one you will need to repeat the steps below !! Bad Luck Lots 2_2.jpg : https://imgur.com/gxRbomU
Choose where to store "Cabinet" File:
KB3054873 Download an 32Bit Win7 Home 2 3.JPG : https://imgur.com/Qbcogpv
Open after the download:
KB3054873 Download an 32Bit Win7 Home 4 5.JPG : https://imgur.com/ouiIe4l
Double click on downloaded file:
KB3054873 Download an 32Bit Win7 Home 6.JPG : https://imgur.com/CVN0rVg
Choose where to "un zip" to:
KB3054873 Download an 32Bit Win7 Home 7.JPG : https://imgur.com/92bcgqg
Save:
KB3054873 Download an 32Bit Win7 Home 8.JPG : https://imgur.com/OhxRL6H
Double click on file to …._
KB3054873 Download an 32Bit Win7 Home 9.JPG: : https://imgur.com/vnwvuuQ
_..... pop up that instillation can't be done
KB3054873 Download an 32Bit Win7 Home 10.JPG : https://imgur.com/RHDmZ9U
( Der Upgradepatch kann vom Windows Installer-Dienst nicht installiert werden, weil das Programm, das aktualisieret werden soll, möglicherweise fehlt, oder weil der Upgradepatch eine andere Version des Programms aktualisieren würde. Stellen Sie sicher, dass das zu aktualisierende Programm auf dem Computer installiert ist, und dass Sie den richtigen Upgradepatch installieren
The upgrade patch can not be installed by the Windows Installer service because the program being upgraded may be missing or because the upgrade patch would update another version of the program. Make sure that the program to be updated is installed on the computer and that you install the correct upgrade patch ) )
So this machine currently has ActiveX embedded in a worksheet controls in Excel 2003 working
( another update reported as breaking ActiveX embedded in a worksheet controls, KB974554 , is still on this computer ).
Sometime later KB3054873 came back.. Around the 25-28thJan 2019 I took another look at this machine, and found that ActiveX embedded in a worksheet controls were broken again
Wul showed now 2 entries
20.01.2019 03:01:46
22.02.2018 03:04:07
( previously it showed one entry 22.02.2018 03:04:07 )
In the computers update list it showed it as installed on 23.01.2019 Martin KB3054873 back 23Jan 2019.JPG , https://imgur.com/NwGOqjY
On removing the update all was well again.( A restart was indicated as necessary. But it wasn't )
_.____________________________
Win 7 Starter ( LG X120 Notebook )
This has had Office 2003 and Office 2007 for several years. ActiveX embedded in a worksheet controls in Excel 2003 have never worked.
None of the currently known "bad" updates where on this computer.
A lot of empirical de installing and re installing was necessary to track down the "bads"
Finally it ways concluded that these two must be removed. I have done that. If I re install either of them then ActiveX embedded in a worksheet controls in Excel 2003 stop working
Update for Microsoft Office Publisher 2007 KB 4011203 Microsoft has released an update to Microsoft Office Publisher 2007. This update provides the latest fixes for Microsoft Office Publisher 2007. In addition, the update includes improvements to security and stability
Update für Microsoft Office 2007 suites KB 2965286 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.
The following I removed, but as it takes a long while to put back I am not sure yet if it causes a problem KB 3213646
During the experiments I de installed other Updates but put them back in so as to narrow down and finally identify the two problem updates. (The shown number of updates in the computer list changed appropriately during this process)
_.____________________
Because of the success on the machines above, I was able to add to my OK list all the updates from the above two computers apart from those found to cause the problem
KB3054873
KB4011203
KB2965286
In addition those last two "new" "bad" updates I have added to my "bad list"
( I have not yet removed KB 974554 from my "bad" list , but I noted that I had that update on one machine that is working. In fact this update "slipped in" recently and is now on my Win 7 Starter ( LG X120 Notebook ), and it continues to work …
Jan-March 2019 New Boot with disc Win 32Bit Home premium
http://www.eileenslounge.com/viewtopic.php?f=18&t=31638
This had either no or a couple of updates after new instillation. I thought I had set this not to get any
1 Start Control Aut____.JPG : https://imgur.com/YWExybc
2 Automatic Updates.JPG : https://imgur.com/zHbzUoB
3 Download but not Install.JPG : https://imgur.com/GUjXEdQ
But it got a lot ( approx 135 ) in middle March anyway (Workbook: "WMI Query Windows7.xls" , Worksheet "Win7 32Bit 20thMarz 2019" ).
Sub UpOKs revealed some new things..
KB2425227 16/01/2019 12:32:43
KB2425227 20/01/2019 03:15:30
KB3004375 17/03/2019 16:30:07
KB3163589 16/01/2019 12:32:40
KB4486563 17/03/2019 15:08:56
KB4487078 17/03/2019 15:54:45
Sub FindBads() found nothing
No problems noticed, ( so far I only have Excel 2003 installed , and 26 updates were for that )
So I added those 5 updates to the good list
"WMI Query Windows7.xls" : https://app.box.com/s/wm3qcgy5gn4csq0csuk5fp2iqu0hrqxz
Reply With Quote
Bookmarks