Office 2013 update KB 2726958 Problem

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.

December 11th, 2014 11:38am

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

Free Windows Admin Tool Kit Click here and download it now
December 11th, 2014 12:28pm

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.
December 11th, 2014 12:32pm

that fix did not work for my company.
Free Windows Admin Tool Kit Click here and download it now
December 11th, 2014 7:42pm

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
December 11th, 2014 8:22pm

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
Free Windows Admin Tool Kit Click here and download it now
December 11th, 2014 8:22pm

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
December 11th, 2014 8:22pm

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
Free Windows Admin Tool Kit Click here and download it now
December 11th, 2014 8:22pm

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"

December 12th, 2014 12:30am

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"


Free Windows Admin Tool Kit Click here and download it now
December 12th, 2014 8:24am

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"


December 12th, 2014 8:24am

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"


Free Windows Admin Tool Kit Click here and download it now
December 12th, 2014 8:24am

Removing all *.exd files from C:\ drive solved my problems.
December 13th, 2014 9:39am

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"

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

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.

December 15th, 2014 3:28pm

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!

Free Windows Admin Tool Kit Click here and download it now
December 15th, 2014 7:46pm

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

December 16th, 2014 4:16pm

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 21st, 2014 8:40pm

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?
January 7th, 2015 3:03pm

Microsoft Fix it 51031 worked for me!
Free Windows Admin Tool Kit Click here and download it now
January 8th, 2015 12:47am

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

March 12th, 2015 11:00pm

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:14am

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

Other recent topics Other recent topics