none
Office 2013 update KB 2726958 Problem RRS feed

  • Question

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

    Thursday, December 11, 2014 4:31 PM

All replies

  • 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
    Thursday, December 11, 2014 5:22 PM
  • 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.
    Thursday, December 11, 2014 5:25 PM
  • that fix did not work for my company.
    Friday, December 12, 2014 12:36 AM
  • 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"


    Friday, December 12, 2014 5:24 AM
    Moderator
  • Removing all *.exd files from C:\ drive solved my problems.
    Saturday, December 13, 2014 2:32 PM
  • 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"

    Monday, December 15, 2014 4:09 AM
    Moderator
  • 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.


    Marcel Saucier (An old DOS guy since 1983...)

    Monday, December 15, 2014 8:21 PM
  • 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!


    MrMikeV

    Tuesday, December 16, 2014 12:39 AM
  • 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

    Tuesday, December 16, 2014 9:08 PM
  • 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"

    Monday, December 22, 2014 1:31 AM
    Moderator
  • 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?
    Wednesday, January 7, 2015 7:56 PM
  • Microsoft Fix it 51031 worked for me!
    Thursday, January 8, 2015 5:40 AM
  • 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


    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Friday, March 13, 2015 2:59 AM
    Moderator
  • 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
    Friday, May 29, 2015 11:13 AM