I have tried to import data using Powerpivot from Sage 50 v18 (2012) but for some reason it just won't connect to the data using the ODBC datasource connection.
Can anyone help at all. The error message is User ID or Password invalid ": ERROR  User ID or Password invalid
I can import via ODBC and MS Query normally using Excel data connection no problem but Powerpivot just doesn't work even though the ID and password used are exactly the same as importing via Excel. I have reinstalled the Sage ODBC driver to no avail.
Any help much appreciated. Thanks