Since last Tuesday, I haven’t been able to connect to Exact Online from Excel any more.
At first I got a message saying my licence key doesn’t have the required 29 characters (my licence key has almost 2,300 characters). After that, it looks as though the link with Exact Online has disappeared entirely and I have to set everything up again — login name, password and all the OAuth fields.
I can no longer find the data I need for OAuth anywhere in Exact Online. Can it be found somewhere else?
After a long search, I did manage to find the OAuth Client ID, OAuth Client Secret and the redirect URL in Exact Online. I can connect to Exact, but the formulas no longer work — it says an unknown table is being used.
Also, every time I connect, I have to fill in the OAuth Client ID, Client Secret and Redirect URL again, as the OAuth Access Token and OAuth Refresh Token remain empty. Does anyone have an idea what I can do?