Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Bogangar NSW Australia
    Posts
    154
    Thanks
    29
    Thanked 3 Times in 2 Posts

    Excel 2010 - Button on All Worksheets Stop Working - Excel Update Problem?



    Today, after doing a Windows 7 and Microsoft Office Update, none of the ActiveX Control Buttons that select macros or VBA procedures on any of my Excel 2010 Workbooks work any longer. They all worked perfectly yesterday. Today after the Microsoft Office Update - zilch. They no longer respond when clicked.

    Going to the VBA code and running the procedures from there works as expected.

    Trying to insert a new ActiveX Command Button results in the Microsoft Excel error dialogue: "Cannot insert object".

    I get the same response when trying to insert any of the ActiveX Controls.

    (Form Controls appear to insert, but I've never used them as they appear to be restricted to Macros only - I haven't worked out how to attach them to VBA procedures, which I use extensively).

    Has anyone else run into this issue?

    Have you found a solution?

    Where do I find the Uninstall file for removing the offending Microsoft Office Excel Update?

    Fully frustrated at this time....

    Trevor

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Regards,
    Rory

    Microsoft MVP - Excel

  3. The Following User Says Thank You to rory For This Useful Post:

    BygAuldByrd (2014-12-11)

  4. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Bogangar NSW Australia
    Posts
    154
    Thanks
    29
    Thanked 3 Times in 2 Posts
    Hi Rory,

    Thanks for the prompt and very helpful response. I went to your post at http://excelmatters.com/2014/12/10/o...ivex-controls/ and your instructions resolved the issue very quickly.

    Rather than immediately deleting the files I tagged them with a .ZZZ extension so that Excel would not load them, then reloaded Excel. New files with the same names were immediately recreated and on testing the all my ActiveX Control Buttons work as expected. I have since deleted the renamed files.
    Thanks again.

    Trevor
    Last edited by BygAuldByrd; 2014-12-11 at 08:16.

  5. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Glad to help. This sort of thing helps keep us on our toes, I guess...
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #5
    New Lounger
    Join Date
    Dec 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There is a way to rename the *.exd files in VBA even when Excel is running, which can also fix the issue. I've posted the VBA snippet here:

    http://www.excelclout.com/microsoft-...-controls-fix/

    Developers can add the snippet to the spreadsheets they're distributing, and their spreadsheets should be immune to the Microsoft patches. It's not the best solution, but it works for now.
    Last edited by ExcelClout; 2014-12-16 at 17:57.

  7. #6
    Lounger
    Join Date
    May 2007
    Posts
    40
    Thanks
    1
    Thanked 2 Times in 2 Posts
    I should have checked here first, but follow Patch Watch religiously and it said to go ahead with all the Office Patches (Win 7 x64, Office 2010). Did so on Saturday. Everything seemed OK until I discovered on Monday morning that I had lost all button functionality in an important business-related WB. Immediately tried the same wb on a backup XP machine and everything was fine. On my Win 7 system I could not even get rid of the non-working buttons. In a fit of frantic, I uninstalled the culprit Excel Security update -- using a wild guess as to the culprit -- and found I could remove the non-working buttons and re-embed form buttons that ran the macros fine. Lost a lot of time and sweat over this one.
    The culprit update in my case (Win 7 x64, Excel/Office 2010, was Security Update for Microsoft Excel 2010 (KB2910902) 64-Bit Edition, Download size: 24.6 MB

    6rtury

  8. #7
    New Lounger
    Join Date
    Feb 2010
    Location
    Cedar Rapids, IA, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just found this link that fixed the problem for my Excel 2013.
    http://support2.microsoft.com/kb/3025036

    Hope this helps.
    Bob

    edit:
    I used the Fix-it button at the bottom.
    Last edited by rwshreve; 2015-01-16 at 15:12.

  9. #8
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Bogangar NSW Australia
    Posts
    154
    Thanks
    29
    Thanked 3 Times in 2 Posts
    There's more info on this issue in "The Microsoft Support Team Excel Blog" at http://blogs.technet.com/b/the_micro...-updates-.aspx


    Trevor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •