无法启用PowerPivot加载项 [英] Can't get PowerPivot Add-in Enabled
问题描述
您好，
成功安装PowerPivot后，Excel 2010拒绝加载它。 我可以在选项中的加载项组中看到它，但它始终列为非活动。
如果我去管理COM加载项，PowerPivot就在那里，但未选中。 ;如果我检查它，并关闭Excel并重新启动它，它将返回到非活动状态。
我通过事件查看器查看了应用程序，安全性和系统日志，但我找不到任何有关Excel停用PowerPivot的内容。
在我安装的Office 2010中，我确实为每个产品选择了.NET可编程性支持，包括Excel。 我尝试过卸载/重新安装，修复PowerPivot安装。 没有快乐。
任何想法为什么PowerPivot会被停用？
谢谢！ （如果这是错误的论坛，请告知）
Hi
David，
Syswizard’ s链接中的解决方法是否适用于你？
1。
首先，我知道这听起来很愚蠢，但我必须指出它–你必须使用Excel 2010.PowerPivot不能在早期版本的Excel下运行。
2。
接下来确保您在Office安装选项中选中了其他"共享功能"选项。我们需要此功能以支持VSTO。
3。
接下来确保您有COM加载项以查看是否已检查，如果没有检查并再次尝试。
4。
检查PowerPivot for Excel加载项是否已禁用。如果禁用，请启用它并重试。有时Excel默认启用它，或者你没有&rsquo ; t注册后加载项首次出现时接受签名。
检查加载项是否在禁用项目列表中。您可能想知道"为什么Excel禁用PowerPivot？"答案是：答案是如果Excel认为加载项干扰了Excel的使用，它会禁用加载项。这可能是
就像某些启动代码中的延迟一样简单，即你遇到网络‘ hiccup’在错误的时间，或类似的事情。
5。
如果您仍然无法收到有效的错误消息，请尝试此
o < span style ="font：7pt / normal"Times New Roman""
打开我的电脑属性
o < span style ="font：7pt / normal"Times New Roman""
点击高级标签
o < span style ="font：7pt / normal"Times New Roman""
点击环境变量
o < span style ="font：7pt / normal"Times New Roman""
点击新用户变量
o < span style ="font：7pt / normal"Times New Roman""
添加值为0的VSTO_SUPPRESSDISPLAYALERTS按OK
o < span style ="font：7pt / normal"Times New Roman""
通过添加/删除程序修复PowerPivot For Excel
o < span style ="font：7pt / normal"Times New Roman""
再次打开Excel，它会提示错误信息–这可能会让您更好地了解问题。
我期待着听到你的消息。
Hi,
After successfully installing PowerPivot, Excel 2010 refuses to load it. I can see it in the Add-Ins group in Options, but it is always listed as Inactive.
If I go to Manage COM Add-ins, PowerPivot is there, but unchecked. If I check it, and close Excel and restart it, it returns to the Inactive state.
I have looked the Application, Security and System logs through Event Viewer, but I can't find anything regarding Excel inactivating PowerPivot.
In my installation of Office 2010, I did select .NET Programability Support for each product, including Excel. I have tried uninstalling/re-installing, repairing the PowerPivot install. No joy.
Any ideas why PowerPivot keeps getting inactivated?
Thanks! (If this is the wrong forum for this, please advise)
Hi David,
Does the workaround in Syswizard’s link worked for you?
1. First, and I know this sounds dumb, but I have to point it out – you have to be using Excel 2010. PowerPivot does not run under earlier version of Excel.
2. Next ensure that you have the additional “Shared Features” option checked in your Office install options. We need this for VSTO support.
3. Next ensure that you have the COM add-ins to see whether it’s checked, if not check and try it again.
4. Check to see whether or not the PowerPivot for Excel add-in is disabled. If disabled, enable it and try again. Sometimes Excel won’t enable it by default, or you don’t accept the signing when the add-in first comes up after registration. Check whether the add-in is in disabled items list. You might be wondering “Why does Excel disable PowerPivot?” The answer is that if Excel believes that an add-in is interfering with the usage of Excel, it disables the add-in. This could be something as simple as a delay in some startup code, i.e. you hit a network ‘hiccup’ at just the wrong time, or something like that.
5. If you still cannot get a valid error message, please try this
o Open My Computer Properties
o Click on Advanced Tab
o Click on the Environmental Variable
o Click on New User Variable
o Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
o Repair PowerPivot For Excel from add/remove program
o Open Excel again, it will prompt an error message – that might lead you to a better understanding of the problem.
I look forward to hearing of you.
这篇关于无法启用PowerPivot加载项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
