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
Free Windows Admin Tool Kit Click here and download it now
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

Free Windows Admin Tool Kit Click here and download it now
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 :-)...

Free Windows Admin Tool Kit Click here and download it now
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

Free Windows Admin Tool Kit Click here and download it now
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.
Free Windows Admin Tool Kit Click here and download it now
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

Free Windows Admin Tool Kit Click here and download it now
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

Free Windows Admin Tool Kit Click here and download it now
December 14th, 2014 4:08pm

Hi All,

Update 2:

Please see this blog, follow the methods and check if they are help.

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx

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 15th, 2014 4:09am

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?

Free Windows Admin Tool Kit Click here and download it now
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"

Free Windows Admin Tool Kit Click here and download it now
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


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?
Free Windows Admin Tool Kit Click here and download it now
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!!

Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2015 7:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics