Excel formula for exchange rates update not available or linked (excel00430)

Message:

image

excel00430
Class does not support Automation or does not support expected interface.
ValidationException
InvantiveControlUDFs.I_EOL_CRY_EXCHANGE_RATE

Foreign exchange rates are not uploaded in Excel, source Exact online. Why not?

I have to click 5 times 12 months (60 times) before I can continue.

image

The error excel00430 is probably due to a problem with the installation of Excel.

It is recommended to apply an upgrade as outlined in Excel00430: Invantive Control for Excel verschijnt met fout: Class does not support Automation or does not supported expected interface (Dutch) or Excel00430 Class does not support Automation or does not support expected interface (Dutch).

When the upgrade is successful, the version number in Invantive Control for Excel must be different from 20.2.159. The increase of version number can be check through “About Invantive Control for Excel” in the Help-menu.