Martin: Make sure that the econnect service is still running. Go to your Conrol Panel>>Administrative Toolsand Services and make sure that the econnect for Microsoft is running and so is eOne Smart Connect service Looks like one the econnect service is failing. Usually if you stop and restart the service everything will be fine.
We have also seen an issue (although very rarely) where the system that generates the source excel workbook does not do it correctly all the time. We would still be able to open the file to view the data but the ODBC driver would not connect to it.
You can try copy/paste the data out to your own workbook that you have made and save it. Then point the map to your new file to see if it is an issue with the excel file itself.
If you would like to submit an answer or comment, please sign in to the eOne portal.