Due to a different partner model between Invantive and Exact Online some changes are necessary. The steps are described on Register Exact Online app for use with Invantive Control for Excel.
When these steps have been completed, please enter under “Advanced” the client ID, redirect URL https://clientredirect.invantive.com and optionally client secret.