Featured Post

Dynamics GP 2016 R2 is Now Available .. and #MSDynGP will Always be Avilable

The Microsoft Dynamics GP team announced today that Microsoft Dynamics GP 2016 R2 has released . Dynamics GP 2016 R2 continues the grea...

Thursday, February 23, 2017

Smartlist Export Failure - Excel Cannot open file because the File Fomrat or File Extension is not valid


I have received recently a quite "weird" support case, in which the smart list is failing to export data into Excel addressing that Excel can not open the file. Here is the exact error message:

"Excel Cannot open file because the  file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"


Smart list export error

After several troubleshooting attempts suspecting that Excel is the source root cause, it rather appeared that "data" which is being exported is the root-cause of this error. It was found out that the data contains special characters.  Here is the screen shot of the "corrupted" data record which was failing the whole process:


An arrow Symbol (Special Character)


Best Regards, 
Mahmoud M. AlSaadi

2 comments:

  1. I have the problem and until now I couldn't figure out the solution.

    ReplyDelete
    Replies
    1. There must be a specific special character which is spoiling the whole export. Try to remove specific columns in order to check which column is causing this issue.

      Best Regards,
      Mahmoud M. AlSaadi

      Delete