>>>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 Microsoft keeps changing the format, trying to force everyone to keep buying new versions every few years.