This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Why am I receiving the error below when trying to update or install OfficeConnect?
You can run the troubleshooting tool in this article if you encounter an error when installing or launching OfficeConnect. The troubleshooting tool will generate a log file with information related to unexpected errors that could be occurring during the update/installation process.
OfficeConnect is an Excel COM add-in that relies on Excel objects to be registered correctly by the Microsoft Office installation. If the objects aren't registered or there's a problem with that registration, OfficeConnect will not work or install correctly. This issue could also impact other Excel COM add-ins as well, not just the OfficeConnect application.
In some cases, the same machine could have different versions of MS-Office products installed (i.e. Project 2016 and Excel 2013) which can also result in different versions of the MS-VSTO library being installed. This scenario could lead to COM registry errors when updating or installing OfficeConnect. The log file generated by the troubleshooting tool for this scenario will contain the following error message:
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Core.IRibbonUI'. This operation failed because the QueryInterface call on the COM component for the interface …
Some users have reported that repairing or reinstalling Microsoft Office can resolve the error. In other cases, the correction is to make adjustments on the computer regarding the specific registry keys which is based on the identifier of the registry key from the troubleshooting tool.
- For example:
Exception from HRESULT: … <<REGISTRY KEY WILL BE LISTED HERE>>…
- Your company’s IT Department may be able to provide additional information regarding these registry keys.