In case you get an error when trying to generate a report using MS Excel XLS format, then you need to create it using XLSX.  XLS has a limitation of 65535 rows while  MS Excel XLSX goes to 1 Million rows

Indeed the recommendation is to use XLSX always if possible for you as has a better performance so your report will show up quicker