Unsupported File Format

[#1]

Just tried making a new data connection to a folder on our server.  It allows the path to be made but when I try an upload any excel docs from that folder, I get the following message "unsupported file format".  Any ideas on how to troubleshoot or what I might be doing wrong?  I've looked at a variety of posts related to this but don't understand how they resolved...

Thanks!

Meg

[marcus_sommer]

I think the file-format is really wrong. For excel there are two different formats - an older one with (Biff, ...) for xls-files and a newer one (OOXML, ...) for xlsx-files.

- Marcus

[ramkrishna86]

Please check excel file extension or please upload the sample of your file so that i can help you.

[Anonymous]

I had the same issue, with just a regular .XLSX excel file. Not sure why the error occured, but i was able to load the data by going to the data manager and attaching the file.