When trying to use the Excel Add-in and run queries, you receive the following error: 


1.) Enable logging to find out what could be causing the error: 

Follow the steps detailed here

2.) If you get similar errors in the logs as those below, you need to contact your IT team. 

Errors in the 1010data.logs: 

ExecQuery: XML parsing error 4: not well-formed (invalid token)
Error in Sub/Func ExecQuery: 1550 XML parsing error 4: not well-formed (invalid token); Source: Thrown manually

XML logs: 

"Access forbidden
You have browsed from an unrecognized IP address. The proxy therefore denied access to this site or page"

In order to fix this issue, the IT group added an exception to the affected user's profile to allow the user to access the 1010data.com domain name and any web applications. 

3.) Should you see any other error messages in the log files, please do not hesitate to send them to us for further investigation.