Excel Reports Not Working: File format or file extension is not valid

  • Profile Image
    markashton
    Asked on April 22, 2014 at 02:05 PM

    Created an excel report ... Get this ...

     

    have you lot been frigging around with them?

    Client needs this asap - please fix.

    many thanks

    Regards mark

  • Profile Image
    Mike_T
    Answered on April 22, 2014 at 04:10 PM

    We have switched default Excel output from .xls format (Microsoft Excel 97-2003) to up to date .xlsx format (Microsoft Excel 2007 and above).

    Your client should be able to open the file in Microsoft Excel 2007 and above. Alternatively, use a CSV format or convert the .xlsx file to .xls one.

    Thank you.