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
I have the problem and until now I couldn't figure out the solution.
ReplyDeleteThere 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.
DeleteBest Regards,
Mahmoud M. AlSaadi
BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast
ReplyDeleteyou can be to get the new PROGRAMMED blank ATM card that is capable of
hacking into any ATM machine,anywhere in the world. I got to know about
this BLANK ATM CARD when I was searching for job online about a month
ago..It has really changed my life for good and now I can say I'm rich and
I can never be poor again. The least money I get in a day with it is about
$50,000.(fifty thousand USD) Every now and then I keeping pumping money
into my account. Though is illegal,there is no risk of being caught
,because it has been programmed in such a way that it is not traceable,it
also has a technique that makes it impossible for the CCTVs to detect
you..For details on how to get yours today, email the hackers on : (
atmmachinehackers1@gmail.com ). Tell your
loved once too, and start to live large. That's the simple testimony of how
my life changed for good...Love you all ...the email address again is ;
atmmachinehackers1@gmail.com