C5220 Error Occurs on Environment where Multiple Versions of Office Are Installed

Regarding C5220 error, there are some possible causes when it occurs on Datalizer for Excel.

However, if your environment meets the following conditions, try the solutions listed below.

Conditions

• Multiple versions of Office are installed. Or, other version of Office was installed before and currently use only one version.
• It occurs only on certain devices and the other devices don't encounter the error, even if using the same definition file under the same condition.

Trigger

C5220 error may occur if you do the following operations on an environment with the above conditions.

• Run aggregation
• Create/Open summary definition

C5220 error may occur with the following messages:

One or more errors occurred.

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 componet for the interface with IID'{000C03A7-0000-0000-C000-000000000046}' failed due to the following error:Library not registered. (Exception from 　HRESULT:0x8002801D(TYPE_E_LIBNOTREGISTERED)).

*Other messages may be displayed according to the situation.

Solution

Try the following solutions in order from Solution 1. If the solution doesn't match your situation, you can skip it.

Solution 1: Uninstall unnecessary Microsoft Office and use only one version.

If multiple versions of Microsoft Office are installed on your environment, it may cause C5220 error. It is because Datalizer does not support multiple versions of Microsoft Office.

If you currently use only one version of Office, you can skip this solution.

Solution 2: Repair Microsoft Office

If Microsoft Office itself have some problem for some reason, C5220 error may occur.

Repair Office by the following procedure and see if the problem is solved.

<Repair Office Application>

Control Panel -> Programs -> Programs and Features, right-click on the office application and select Change -> Online Repair.

After that, reinstall DatalizerClient and click Application updates.

Solution 3: Remove unnecessary registry information

If you used to use other versions of Office on the same environment, registry information of the former version that should have been deleted may remain.

Retrieve the system information of your environment by the following procedure and send it to us.

We will check to see if unnecessary registry information remains.

How to Get System Configuration Information for Dr. Sum?