Windows 2010更新后Excel 2010 ActiveX控件不再工作[重复]

This question already has an answer here:

这个问题在这里已有答案：

Microsoft Excel ActiveX Controls Disabled? 11 answers
Microsoft Excel ActiveX控件已禁用？ 11个答案

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).

因此，在我安装了最新的Windows 7更新（包括Microsoft Office 2010更新）之后，我遇到了这个问题 - 更新的日期是今天（2014年12月12日）。

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.

更新后，我在Excel 2010中打开了启用宏的工作簿，基本上任何引用ActiveX控件（复选框，按钮）的工作都不再有效。我的auto_open正在检查复选框，无法运行...它在第一个复选框检查时保持错误。按钮也不再可点击。

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.

在您说出之前，我已检查了我的信任设置并允许所有ActiveX和宏，但没有更改。如果有人有任何建议，我会全力以赴。由于我不是一个管理员，我不能因为Windows的太多事情。

3 个解决方案

#1

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

我们昨天在使用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

通过逐个回滚办公室的安全更新，我们确定这是由2014年12月9日更新KB2596927引起的 - 链接

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!

在此次更新之后，由于ActiveX控件被杀死，不仅许多启用宏的工作表在激活宏时崩溃，而且还不能再将经典的ActiveX控件（按钮，复选框等）插入到空白工作簿中！

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!

CONFIRM AS SOLVED：我可以确认删除文件C：\ Users \ USERNAME \ AppData \ Local \ Temp \ Excel8.0 \ MSForms.exd的答案对我有用！

Thank you guys!

感谢你们！

Here is more information on EXD files

以下是有关EXD文件的更多信息

This was resolved also in another post on this forum

这也在本论坛的另一篇文章中得到了解决

#2

Resolved issue !

已解决的问题！

Close Excel
关闭Excel
Rename or delete this file (at your own risk) : C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd
重命名或删除此文件（风险自负）：C：\ Users \ USERNAME \ AppData \ Local \ Temp \ Excel8.0 \ MSForms.exd

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

Excel重新打开后将重建。我的ActiveX et宏工作得很好！

Have a good day !

祝你有美好的一天！

Cracki

#3

As a quick fix and workaround use this tool:

作为快速修复和解决方法，请使用此工具：

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

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

Basically remove all “.exd” files which represent the cache of the forms.

基本上删除所有表示表单缓存的“.exd”文件。

#1