Power Pivot加载项不是Excel 2013中的选项 [英] Power Pivot Add-in is not an option in Excel 2013

问题描述

你好，

我有2013年的excel，我在启用Power Pivot功能时遇到了问题。 我已按照所有必要步骤尝试在文件>选项>加载项> COM加载项中启用该工具，但它未在下拉列表中列出。我也查看了"禁用
项目"，但仍然没有运气。 我该如何解决这个问题？我是否必须卸载2013并安装2010和Power pivot功能？

解决方案

>>>我已按照所有必要步骤尝试在文件>选项>加载项> COM加载项中启用该工具，但它未在下拉列表中列出。我也查看了"残疾人物品"，但仍然没有运气。 我该如何解决这个问题？
我必须卸载2013并安装2010和Power pivot功能吗？<<<

根据您的描述，Excel 2013中的PowerPivot是一个加载项您可以使用Excel 2013中执行功能强大的数据分析。该加载项可在Microsoft Office Professional Plus中使用。它内置于Excel 2013中，但未启用。如果Excel 2013加载项的MicrosoftOfficePowerPivot
未按预期显示在"COM加载项"对话框中，则会出现此问题，因为向加载项管理器提供加载项信息的注册表项已损坏或已设置要解决此问题，请按照以下步骤删除受影响的注册表项：

1.退出Excel 2013。

2.启动注册表编辑器。为此，请对您的操作系统使用适当的方法，如下所示：

•在Windows 7中，单击"开始"，单击"运行"，键入regedit，然后单击"确定"。

•在Windows 8中，单击"开始"，在"开始搜索"框中键入regedit，然后按Enter键。

3.找到上面描述的注册表项"注释"遵循此过程的部分。

4.右键单击相应的注册表项，然后单击"删除"。

5.Exit注册表编辑器。

6.启动Excel 2013。

7.单击"选项"，单击"加载项"，在"管理"列表中选择"加载项"，然后单击"确定"。走。

有关详细信息，请单击
here 引用COM加载项不会显示在Excel 2013的COM加载项对话框中，并且

here 请参考Microsoft Excel加载项中的启动Power Pivot

Hello,

I have excel 2013 and am having trouble enabling the Power Pivot feature.  I have followed all necessary steps and tried enabling the tool in File>Options>Add-in>COM Add-in, but it is not listed in the drop down list. I also looked under 'disabled items' and still no luck.  How do I fix this issue? Do I have to uninstall 2013 and install 2010 and the Power pivot feature?

解决方案

>>> I have followed all necessary steps and tried enabling the tool in File>Options>Add-in>COM Add-in, but it is not listed in the drop down list. I also looked under 'disabled items' and still no luck.  How do I fix this issue? Do I have to uninstall 2013 and install 2010 and the Power pivot feature?<<<

According to your description, PowerPivot in Excel 2013 is an add-in you can use to perform powerful data analysis in Excel 2013. The add-in is available in Microsoft Office Professional Plus. It’s built-into Excel 2013 but is not enabled. if MicrosoftOfficePowerPivot for Excel 2013 add-ins do not appear in the COM Add-Ins dialog box as expected, this issue occurs because the registry keys that provide the add-in information to the Add-in Manager are damaged or set to invalid values.

To work around this issue, follow these steps to delete the affected registry keys:
1.Exit Excel 2013.

2.Start Registry Editor. To do this, use the appropriate method for your operating system, as follows:
•In Windows 7, click Start, click Run, type regedit, and then click OK.
•In Windows 8, click Start, type regedit in the Start Search box, and then press Enter.

3.Locate the registry keys that are described in the "Notes" section that follows this procedure.

4.Right-click the appropriate registry entry, and then click Delete.

5.Exit Registry Editor.

6.Start Excel 2013.

7.Click Options, click Add-Ins, select Com Add-Ins in the Manage list,and then click Go.

For more information, click here to refer about COM add-ins are not displayed in the COM Add-Ins dialog box in Excel 2013 and here to refer about Start the Power Pivot in Microsoft Excel add-in

这篇关于Power Pivot加载项不是Excel 2013中的选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！