KB2553154 (Security Update to Office 2010) breaks my Visual Basic Macro buttons in Excel
Hi
I'm normally not following this forum, but I've just used 3 hours debugging at a customer because some customized buttons in an Excel book has stopped working...
Insted of calling the Visual Basic functions they used to call, they do nothing...
The mouse arrow changes to a "move arrow" (arrows pointing in all 4 directions) where hovering the button, but nothing else happens...
This issue was caused by KB2553154 released yesterday (i guess) on a Danish Windows 7 / Office 2010.
Removing KB2553154 using Control Panel uninstall program/uninstall updates fixed the issue on two separate installations...
Just wanted to share this so others don't have to spend time debugging :-)....
Regards,
Gert
December 11th, 2014 2:50pm
This patch just burned me today.
Another solution I found is to remove *.exd files in:
- C:\Users\[user name]\AppData\Local\Temp\Word8.0
-
C:\Users\[user name]\AppData\Local\Temp\Excel8.0
Hope this helps.
-Troy Wickard
-
Marked as answer by
Gert Lynge
Thursday, December 11, 2014 4:25 PM
December 11th, 2014 3:33pm
Hi Troy Wickard
Thanks, I can confirm that your solution also works.
Regards,
Gert Lynge
December 11th, 2014 4:03pm
Hi Gert
Glad you have it working.
However, you need to know that many people read these forums to seek answers. Thus you:
1. Preferably tell what solved your question
2. Tell who gave you the answer
3. Give credit to that person
December 11th, 2014 4:18pm
This was a horrible update. No warning from Microsoft before or help afterward. Removing the EXD files from following directories worked well.
- C:\Users\[user name]\AppData\Local\Temp\Word8.0
-
C:\Users\[user name]\AppData\Local\Temp\Excel8.0
thanks guys.
December 11th, 2014 4:26pm
I know, but unfortunately I'm not able to mark my own initial message as answer although it contains a solution:
---
This issue was caused by KB2553154 released yesterday (i guess) on a Danish Windows 7 / Office 2010.
Removing KB2553154 using Control Panel uninstall program/uninstall updates fixed the issue on two separate installations...
Just wanted to share this so others don't have to spend time debugging :-)....
---
I've just marked Troys message as answer as he had another solution.
I did in fact mark is as useful when I made my reply :-)...
December 11th, 2014 4:28pm
Gert,
MS people even mark their questions as "answers" and gain points. Why cannot you? :)
December 11th, 2014 4:32pm
It kills ActiveX controls - Excel cannot see them, throwing errors when the code tries to touch them.
Also impossible to Insert new ActiveX Controls.
I had same problem, found same solution, verified on 2nd machine.
This is three months with bad patches in a row.
Somebody is asleep at the switch.
Thanks for posting your solution - I hope it saves time for others
December 11th, 2014 6:34pm
You do not have to uninstall updates anything.
This is a link to bat file fixed ActiveX problems in Excel and Word
In this file you can find this line:
@del "C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\*.exd" /s
@del "C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms\*.exd" /s
@del "C:\Users\%USERNAME%\AppData\Local\Temp\Excel8.0\*.exd" /s
@del "C:\Users\%USERNAME%\AppData\Local\Temp\VBE\*.exd" /s
@del "C:\Users\%USERNAME%\AppData\Local\Temp\Word8.0\*.exd" /s
I's safe to use with no admin rights
Regards
December 11th, 2014 7:44pm
It is not realistic for us to fix heavily embedded ActiveX code on a per machine basis. Microsoft, please release a patch for this patch. Until then we have alerted our users to avoid auto updates.
December 12th, 2014 3:50am
Hi All,
We have collected this information about this issue (Dec 9 Office updates), and reported it with internal ways. If there are any updates, we will let you know.
Thanks for you understanding.
=====
Update:
Microsoft support team aware of this issue and have drafted a KB to address this issue. The team is working with the FixIt team to get the automated solution implemented into the KB.
Please be patient while we fix the remaining problems over the next little while.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"
December 12th, 2014 5:23am
This also affects Office 2007. In that case, update KB2596927 seems to be the problem.
Uninstalling KB2596927 returns functionality.
Removing the *.exd files and letting them rebuild with the update in place also works.
The latter seems the better solution. See
https://technet.microsoft.com/library/security/ms14-082
Bill Blanton
December 13th, 2014 1:27pm
Deleting *.exd not working for Excel 2013 and Win 8.1
December 14th, 2014 2:18am
Program & Features, right click, repair
Did work for me. Be ready for keys or account access, everything is reinstalled...
Pffff... What a pity
December 14th, 2014 4:08pm
Right now, the simplest solution is just to remove the faulty patch. How about if you guys just fix that, instead of proposing a multitude of labor-intensive solutions that have to be applied to every workstation?
December 15th, 2014 2:33pm
Does anybody know: if MS fixes the bad patch and releases it, will it go out under a new KB#? I have "hidden" the bad patch from about half my workstations, and would be really ticked if I had to now go back and UNhide them so that the
fixed patch installs.
Bother!
December 15th, 2014 9:03pm
Hi all,
Microsoft has release the fix when Dec.19, please try it with below link:
https://support.microsoft.com/kb/3025036/EN-US?wa=wsignin1.0
Hope it's helpful.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"
December 22nd, 2014 1:32am
Hi George
the fix is ok to delete all the respective exd files. But it creates new problems: Excel creates a new exd file. When I then save a workbook containing macros (eg containing the wb.sheets(i).activate command), this file gets corrupted. See also here:
https://social.technet.microsoft.com/Forums/exchange/en-US/3f29c84b-97ad-46f7-9bc0-8648d69336ce/kb2553154-breaks-our-excel-macros?forum=officeitproprevious, (entry of Friday,
December 19, 2014 5:02 PM)
http://www.herber.de/forum/archiv/1396to1400/1398732_Excelverhalten_nach_Update.html.
urgent help required!!
regards, Stefan
-
Edited by
Stefan Hunziker
Monday, December 22, 2014 10:59 AM
December 22nd, 2014 10:56am
Hi all,
Microsoft has release the fix when Dec.19, please try it with below link:
https://support.microsoft.com/kb/3025036/EN-US?wa=wsignin1.0
Hope it's helpful.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"
How about if you guys just fix the bugged update rather than keeping the buggy update and posting a workaround that requires us to walk around to every PC we have?
December 22nd, 2014 2:42pm
I agree, I have deleted files, uninstalled updates, no luck. Microsoft Just send a update fix....
December 22nd, 2014 9:54pm
THANK YOU SO MUCH!
Worked like a charm!!
January 8th, 2015 9:09pm
So this is it? Complete silence from Microsoft? The patch is still broken, but they have no interest in fixing it?
Thanks for the giant SCREW YOU, Microsoft.
January 12th, 2015 2:41pm
If you are in an enterprise environment and macros still do not work on client user profiles after all the updates are installed on machines, you can fix this issue by changing the Office 2010 GPO setting for Check ActiveX Objects to: Override IE kill
bit list
Office 2010 GPO > ADM > Microsoft Office 2010 > Security Settings > Trust Center > Check ActiveX objects: change to Override IE kill bit list
Office 2010 GP Admin Templates
https://www.microsoft.com/en-au/download/details.aspx?id=18968
GP for Office 2010
https://technet.microsoft.com/en-us/library/cc179176%28v=office.14%29.aspx#Administrative_templates
http://blogs.technet.com/b/srd/archive/2008/02/06/the-kill_2d00_bit-faq_3a00_-part-1-of-3.aspx
Regards,
Adrian
May 29th, 2015 7:01am