DataFormat.Error: File contains corrupted data.

[Anonymous]

Hello All, Kindly help, 

I have loaded excle file and it is giving "DataFormat.Error: File contains corrupted data." and not giving me the option to edit. 

Any suggestions. 

[ATahawy]

You cann't access C3 files, so you'll will need to change that

[AnkitKukreja]

Hi! @Anonymous 

Can you check that your excel file has correct data type for all columns and there are no special characters in your data. The error seems to be due to the source file.

[Anonymous]

The problem is the excel files are password protected, after posting this help request. i noticed the files are loaded to share point with password protected. 

[edhans · Accepted solution]

You cannot access password protected files, so that will need to be removed unfortunately.

[jneuey5]

Hi, we are having the same issue after a system update on the program that generates the reports. They aren't password protected, is there something else we can try?

[jazalex]

Hi, I think we might be having the same issue. Do you use Wdesk, and were you able to find a solution?

[jneuey5]

We've had to open each new report in Excel and enable editing. Checking with our IT to see if that can be turned off

[kp_wood13]

Did you find an answer to this question?

[willduff]

If your query is collecting Excel files from a folder, it might be that a hidden file is located in the folder. These files have file names preceded by a dollar sign ($). View hidden items in the source folder and delete any files beginning with a dollar sign ($). This has happened to me several times.