Excel 2010 ActiveX Controls No Longer Working After Windows Updates

excel activex activexobject vba
Brady picture Brady · Dec 11, 2014 · Viewed 42.2k times · Source

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.

Answer

roaseao picture roaseao · Dec 11, 2014

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

Related questions

Microsoft Excel ActiveX Controls Disabled?

I have some Excel worksheets that use ActiveX checkboxes to control certain activity. They worked recently but today started to give errors. I was alerted to this by a colleague, but it was still working on my computer. I checked …

Read More
What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Using Microsoft Excel 2010, I noticed two kind of controls that can be inserted into a document: Form Controls and ActiveX Controls. What is the difference between them?

Read More
"Cannot insert object" error when adding ActiveX control like Microsoft DataGrid to Excel sheet

One of the users of our iGrid ActiveX grid control needs to insert it directly into an MS Excel sheet, but they have not managed to do that - the "Cannot insert object" error is generated all the time. We …

Read More