Excel 2010 ActiveX控件在Windows更新后不再工作 [英] Excel 2010 ActiveX Controls No Longer Working After Windows Updates
问题描述
因此，在安装了最新的Windows 7更新（包括Microsoft Office 2010更新）后，我遇到此问题 - 更新日期（2014年12月12日）。
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).
更新后，我在Excel 2010中打开了支持宏的工作簿，基本上任何引用ActiveX控件（复选框，按钮）的工作都不再工作。我的auto_open正在检查复选框，无法运行...它在第一个复选框检查中保持错误。按钮也不再可点击。
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.
在你说完之前，我已经检查了我的信任设置，并允许所有的ActiveX和宏，但没有改变。如果有人有任何建议，我都是耳朵。由于我不是一个管理员，我无法做出太多的事情，就像Windows一样。
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.
推荐答案
我们昨天在Excel 2007的几台机器上有一些令人震惊的问题。
We had this somewhat shocking issue yesterday on several machines with Excel 2007.
通过逐个回滚Office的安全更新，我们确定这是由2014年12月9日起的更新 KB2596927 引起的 - 链接
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
此更新后，不仅有许多宏启用由于ActiveX控件被杀死，工作表会分解激活宏，同时也不能将经典的ActiveX控件（按钮，复选框等）插入到空白工作簿中！
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：我可以确认删除文件 C：\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd的答案为我工作！
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!
谢谢你们！
以下是有关 EXD文件
这个也在另一篇文章中解决了这个论坛
This was resolved also in another post on this forum
这篇关于Excel 2010 ActiveX控件在Windows更新后不再工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
