The solution !
There are two parameters for the Connection string. The one I had
missing was:
Network = xxxxxxx
Another that is relevant for dynamic port machines (?) seems to be the:
Address = yyyyyyy,port

Hope it works for others.

I have just run the spreadsheet from a machine that needed no
configuration of ODBC etc.