Smartsheet ODBC connector not working - but only for Excel
I have ODBC connector installed. It was working fine with Excel until we switched to single sign on. Then it broke.
I have followed instructions on using an API key for connectivity. These have not worked. I assumed this was an issue at the connector level.
HOWEVER: I have just tried to connect using MS Access. The ODBC connection asked for an API key, then worked immediately, so the connector is working.
In Excel though, I get the message below. I cannot make it work. What am I doing wrong please?