Our pcs applied the latest round of Windows Updates yesterday and the Office Update KB2726958 caused the macros in Excel 2013 spreadsheets to stop working. Uninstalling just this update returned full functionality to Excel.

These are all Windows 7 64 bit machines connected to an AD domain with 32-bit Office 2013 Professional or Pro Plus.

Any machine that had applied the latest updates released on Tuesday suffered from this problem. Opening a .xlsm spreadsheet looked fine but users were unable to click on Macro buttons to e.g. load a userform.

I have spent 28 minutes on the phone trying to speak to somebody, anybody, in Support but no-one was interested so I am trying this forum instead.

I have since read this thread https://social.technet.microsoft.com/Forums/en-US/27e0cba5-e6a5-4280-a23c-ebb47600a400/kb2553154-security-update-to-office-2010-breaks-my-visual-basic-macro-buttons-in-excel?forum=excel which sounds very similar although references a different Update.

The answer from Troy Wickard about deleting the files in 

• C:\Users\[user name]\AppData\Local\Temp\Excel8.0

works without having to remove the offending Update

This thread https://social.technet.microsoft.com/Forums/en-US/b8f0af82-0bb8-4799-aa62-1dbcbc5b7742/excel-2010-macros-does-not-work-after-updates-9dec2014?forum=excel is also very similar and suggests removing the same files.

that fix did not work for my company.

I have since read this thread https://social.technet.microsoft.com/Forums/en-US/27e0cba5-e6a5-4280-a23c-ebb47600a400/kb2553154-security-update-to-office-2010-breaks-my-visual-basic-macro-buttons-in-excel?forum=excel which sounds very similar although references a different Update.

The answer from Troy Wickard about deleting the files in 

• C:\Users\[user name]\AppData\Local\Temp\Excel8.0

works without having to remove the offending Update

• Proposed as answer by janand3050 21 hours 33 minutes ago

I have since read this thread https://social.technet.microsoft.com/Forums/en-US/27e0cba5-e6a5-4280-a23c-ebb47600a400/kb2553154-security-update-to-office-2010-breaks-my-visual-basic-macro-buttons-in-excel?forum=excel which sounds very similar although references a different Update.

The answer from Troy Wickard about deleting the files in 

• C:\Users\[user name]\AppData\Local\Temp\Excel8.0

works without having to remove the offending Update

• Proposed as answer by janand3050 Saturday, December 13, 2014 2:28 PM

I have since read this thread https://social.technet.microsoft.com/Forums/en-US/27e0cba5-e6a5-4280-a23c-ebb47600a400/kb2553154-security-update-to-office-2010-breaks-my-visual-basic-macro-buttons-in-excel?forum=excel which sounds very similar although references a different Update.

The answer from Troy Wickard about deleting the files in 

• C:\Users\[user name]\AppData\Local\Temp\Excel8.0

works without having to remove the offending Update

• Proposed as answer by janand3050 Saturday, December 13, 2014 2:28 PM

I have since read this thread https://social.technet.microsoft.com/Forums/en-US/27e0cba5-e6a5-4280-a23c-ebb47600a400/kb2553154-security-update-to-office-2010-breaks-my-visual-basic-macro-buttons-in-excel?forum=excel which sounds very similar although references a different Update.

The answer from Troy Wickard about deleting the files in 

• C:\Users\[user name]\AppData\Local\Temp\Excel8.0

works without having to remove the offending Update

• Proposed as answer by janand3050 Saturday, December 13, 2014 2:28 PM

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.

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"

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.
experience.

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"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 9 hours 26 minutes ago update

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.
experience.

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"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, December 15, 2014 2:33 AM update

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.
experience.

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"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, December 15, 2014 2:33 AM update

Removing all *.exd files from C:\ drive solved my problems.

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"

This, finally, fixed the problem for me (on 3 computers):

* Search & erasing all *.exd files then,

* Office program or suite: REPAIR (seems to fully reinstall, have keys or account info ready)

I have turned off all Office automatic updates... now...

I understand this is not a viable solution for those managing many computers.

Performing the steps in the link (http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx) does restore the ability to run button driven macros as well as add controls and buttons.

However, a task as simple as:

1. Creating a new workbook.
2. Saving as macro enabled workbook.
3. Adding ActiveX form toggle button.
4. Adding: msgbox "Toggle this!" to the change even of the newly added toggle button.
5. Saving the workbook.
6. Everything works great on this machine.

 When the workbook is opened on another machine (I've tried several that can open and use other macro enabled workbooks with buttons and such.), the button appears, but the button and macro are not functional.  Deleting the sheet in the workbook causes Excel to crash. 

Once I uninstalled KB2726958 on the machine where the workbook is created, I am able to perform the above with no issues.  Of course, this is a temporary work around that will be clobbered by policy driven Windows /Office Updates the next time I restart. 

HALP!

George.  Thanks for your update.

This problem is worse than the Microsoft related articles imply. Note that for me, removing old %temp%...exd's did not workaround the ActiveX problems that this introduced.  It caused all my workbooks with controls to fail - they simply do not recognize ActiveX controls anymore.  You could not even add one into a brand new workbook.

For the record I have Windows 7 with Excel 2010 SP2 (14.0.7140.5002 x64) AND Excel 2013 (15.4667.1002 x64)    They both stopped recognizing ActiveX controls.  The ONLY way to fix it was to REMOVE KB2553154 (I did not have KB2726958).

The same xlsm Workbook worked on other computers (Windows 8.1 / Excel 2013 and Windows Server 2012 / Excel 2010) - but fortunately, I do not do NOT do automatic updates - I just let it download them automatically. I will wait even longer from now on and never install any recent ones. 

Regards

Fred

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"

Ok, I've noticed this hack works.  But I've also noticed that once Excel runs again, it puts a similar file back in that location.  Should I be worried about this issue in the future?

Microsoft Fix it 51031 worked for me!

Hi all,

Hotfixes for this issue have been released in the March 2015 Updates for Office 2007, 2010 & 2013.

Please see here:

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
TechNet Community Support

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