>>>>By the way it was an xslx file which I saved as a xls file
>>>
>>>Well if you have the luxury to save it in a different format, why not CSV?
>>
>>
>>cav worked fine
>>
>>sorry I meant why didnt the xls file work
>
>Because MS changed something.
>If you use MS Office 2010 or newer you should save XLS as Excel 5.9/95 format.
>97 format works only if you have MS Office 2007.

Thanks