Excel COM添加在启动过程中未加载，必须手动添加 [英] Excel COM add is not loading during startup and have to add it manually

问题描述

Excel COM加载项在启动过程中不会加载，每次我都必须手动添加时。在检查文件>选项>加载项>管理-> COM加载项后，我看到加载项处于已卸载状态。不确定如何使其在启动时自动加载。

Excel COM addin is not loading during starting up and each time I have to add it manually. After checking the File > OPtions > Add-ins > Manage -> COM addins, I see that the 'add in' is in 'Unloaded' state. Not sure how to make it automatically load at startup.

推荐答案

这是为我解决问题的方法。

Here's what fixed the issue for me.

步骤：

1. 开始>键入'regedit'

1. Start > type 'regedit'

导航到HKEY_CURRENT_USER\软件\Microsoft\Office＼ ＼Excel\Addins

Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins

然后将HyperionComAddin的loadBehaviour值更改为3。如下所示。为了澄清起见，这是我在启动过程中未加载的加载项。

Then change the value of loadBehaviour to 3 for HyperionComAddin. As shown below. Just to clarify, this is the add-in that was not loading during start up for me. Picture in the question is to give an example.

关闭注册表并重新打开以确保值未更改。

Close registry and reopen it to make sure that value has not changed.

现在重新启动excel。

Now restart excel.

这篇关于Excel COM添加在启动过程中未加载，必须手动添加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！