If you are in an Inxl worksheet and click on Get Data and are getting the message 'has no Valid Datasets, please use Access InXL Manage Data Connections menu item' then please do the following:
In Microsoft Excel, click the InXL tab
Click Manage Data Connections
Check the connection information. Once it is correct you will have a green tick against the connection entry.
Click Get Data again.