Issue
When using query Excel services, the data for .xsl files is not queried.
Resolution
In Excel, save the file in .xlsx format.
For more information, see Excel Services: Old XLS won't open in browser while XLSX do in Microsoft TechNet, Excel Services: Supported File Format and Features in Microsoft Developer Network and What is the real difference between a .xls vs .xlsx file ? in Microsoft Community