Excel 2010 ActiveX controls no longer work after Windows updates

Question

So, at work, I encountered this problem after installing the latest Windows 7 updates (including Microsoft Office 2010 updates) - the date of the update was today (December 12, 2014).

After the update, I opened the book with the macro turned on in Excel 2010, and basically everything that referred to ActiveX controls (checkboxes, buttons) no longer worked. My auto_open checked the flags and could not work ... it saved an error the first time the flag was checked. Buttons are also no longer clickable.

Before you say that, I checked my trust settings and allowed all ActiveX and macros, but no changes. If anyone has any advice, I'm all ears. Due to the fact that I am not an administrator, I cannot because of too much with Windows.

Answer 1

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

Rollback of security updates for the office one by one, we determined that this was caused by the update KB2596927 from December 9, 2014 - Link

After this update, not only many worksheets with a macroblock broke when activating macros due to their destruction of ActiveX controls, but also no classic ActiveX controls (button, checkbox, etc.) could be inserted into an empty book anymore!

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

Thanks guys!

More about EXD files

This was also permitted in another post on this forum.

Answer 2

Solved problem!

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

It will be restored after opening Excel. My ActiveX and macros work well!

Have a nice day!

Cracki

Answer 3

As a quick fix and workaround, use this tool:

http://go.microsoft.com/?linkid=9875022

https://support.microsoft.com/kb/3025036

Basically delete all “.exd” files that are forms cache.