Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Excel 2010 ActiveX Controls No Longer Working After Windows Updates [duplicate]

So at work I ran into this issue after I installed the most recent Windows 7 updates (including Microsoft Office 2010 updates) - the date up the update was today (Dec 12, 2014).

After the update, I opened my macro enabled workbook in Excel 2010 and basically anything that referenced ActiveX controls (checkboxes, buttons) no longer worked. My auto_open was checking checkboxes and couldn't run... it kept erroring at the first checkbox check. The buttons are also no longer clickable.

Before you say it, I have checked my trust settings and allowed all ActiveX and Macros, but no change. If anyone has any advice, I'm all ears. Due to me not being an admin, I cannot due too many things as far as Windows goes.

like image 679
Brady Avatar asked Dec 11 '14 02:12

Brady


People also ask

How do I enable ActiveX in Excel 2010?

Use the following instructions to enable or disable ActiveX controls in the Trust Center. Click File > Options. Click Trust Center > Trust Center Settings > ActiveX Settings. Click the options you want, and then click OK.

How do I install ActiveX controls in Excel 2010?

Add an ActiveX control On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, select a control, or click More Controls to view all the available ActiveX controls, and then select a control. Click the worksheet location where you want the ActiveX control to appear.

What's the difference between ActiveX and form controls in Excel?

If the shortcut menu contains the command Properties, the control is an ActiveX control, and you are in design mode. If the shortcut menu contains the command Assign Macro, the control is a Form control.


2 Answers

We had this somewhat shocking issue yesterday on several machines with Excel 2007.

By rolling back Security updates for office one by one, we determined that this was being caused by update KB2596927 from 9 December 2014 - Link

After this update, not only did many macro-enabled worksheets break down upon activating macros due to their ActiveX controls being killed, but also no classic ActiveX controls (button, checkbox, etc.) could be inserted into a blank workbook any longer!

CONFIRM AS SOLVED: I can confirm that the answer to delete the file C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd has worked for me!

Thank you guys!

Here is more information on EXD files

This was resolved also in another post on this forum

like image 153
roaseao Avatar answered Oct 17 '22 17:10

roaseao


Resolved issue !

  • Close Excel
  • Rename or delete this file (at your own risk) : C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd

It would be rebuild after Excel reopens. My ActiveX et macros are working good !

Have a good day !

Cracki

like image 2
cracki Avatar answered Oct 17 '22 18:10

cracki