none
command buttons stopped working after 10 Dec 2014 updates RRS feed

  • Question

  • I have a spreadsheet in Excel 2007 which has several command buttons that do calculations. They were working as usual this morning. I installed today's updates. Restarted my computer and now none of the command buttons work. When I hover over the button the cursor remains, there is no up arrow and the command doesn't work. Is there any way to fix this or to back out all the office updates?
    Thursday, December 11, 2014 2:13 AM

Answers

  • Quit Excel.
    Start Windows Explorer.
    Select the system drive (usually C:).
    Use the Search box to search for *.exd
    Delete all found files.
     
    (Thanks to Excel MVP RoryA for this tip)

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thursday, December 11, 2014 7:23 AM

All replies

  • Quit Excel.
    Start Windows Explorer.
    Select the system drive (usually C:).
    Use the Search box to search for *.exd
    Delete all found files.
     
    (Thanks to Excel MVP RoryA for this tip)

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thursday, December 11, 2014 7:23 AM
  • What else can i do ?

    I  did not find any *.exd files

    Boaz

    Thursday, December 11, 2014 8:01 AM
  • Hans,

    That worked liked a charm. Thank you.

    Betty

    Thursday, December 11, 2014 1:50 PM
  • What else can i do ?

    I  did not find any *.exd files

    Boaz


    Make sure that Windows Explorer displays hidden files and folders.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thursday, December 11, 2014 4:10 PM
  • Hans,

    Seemed to take several reboots but .exd files finally showed up. I deleted them and "Bingo" works like a charm! I passed this link along to our application support team as the resolution.

    Thank you very much!

    Gratefully,

    Darin

    Friday, December 12, 2014 4:16 PM
  • Thanks  Hans

    I have displayed Hidden files and folders

    I have turnd my computer off and on more than 10 times and still I do not find any *.exd files

    does anyone have another Idea that could help ?

    Boaz

    Sunday, December 14, 2014 8:49 AM
  • Here is the official Microsoft reaction to this problem:

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


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, December 14, 2014 10:26 AM
  • Thank you Hans

    I have set Windows Explorer to displays hidden files and folders
    I have restarted my computer more than 10 times

    But still I have'nt found any *.exd files

     

    Does anyone have another idea

    I have found a way to make new buttons and assign macros to them to replace the old buttons but I don't know how to write a macro for a ComboBox and how to assign a list to it with out the properties option.

    Please advise

    Boaz

    Sunday, December 14, 2014 12:05 PM
  • Have you tried uninstalling the update that causes it?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, December 14, 2014 2:19 PM
  • Have you tried uninstalling the update that causes it?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thank you Hans

    I have uninstalled the update and on office 2010 it did the trick with relatively small side effects.
    on office 2007 it didn't work for some reason but I only have one computer with that software so Ill manage with out it.

    Thank you again for your patience and your help.

    Boaz

    Tuesday, December 16, 2014 6:29 AM
  • Have you tried uninstalling the update that causes it?


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thank you Hans

    I have uninstalled the update and on office 2010 it did the trick with relatively small side effects.
    on office 2007 it didn't work for some reason but I only have one computer with that software so Ill manage with out it.

    Thank you again for your patience and your help.

    Boaz

    Same problem again !

    Two days have passed and the update I have removed has reinstalled itself ! (KB2553154)
    this happened despite the fact that I have set automatic updates to ask for approval before installing any more updates.

    how can I stop this from happening ?

    Do I have to go threw every computer in the company every other morning and check if the updates have returned ?

    Boaz

    Wednesday, December 17, 2014 7:39 AM
  • It's possible to hide an update in Windows Update:

    After uninstalling the update, start Windows Update and let it search for new updates.

    KB2553154 should be listed. Right-click it and select Hide Update from the context menu.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, December 17, 2014 12:52 PM
  • I think I have the same problem as you.

    See the thread: "Excel 2007 AcciveX support"

    Exactly when it happened I do not know. In my case I also can not find any .exd file extensions

    When you read my thread you will see some workarounds but that is ofcourse not what I want.

    I think the best solution is to remove Excel 2007 all together (if Microsoft advices me). I do not know which path to follow to reinstall Excel 2007 nor if that will fix the problem. After that I can install the required updates and see if something goes wrong.

    Succes

    Nicolaas Vroom

    Friday, January 9, 2015 3:46 PM