Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a small problem and I hope you can help me figuring out the reason behind it.
I have an app I finished creating a while ago and it was just sittiing there. Everything was working just fine. There has not been any changes made in the script or in the source files. I opened it and tried to make a reload, but got an error message "External table is not in the expected format". The files are xlsx format. What could be the reason behind it?
Hi,
check your source excel file version and re-point your odbc dsn - excle file.
also check this thread.
Could you elaborate on "re-point your odbc dsn - excle file."?
I am loading multiple files using a for loop. How can I point to them (or folder to me more exact)?
You might not notice them but I think there are any changes somewhere. If you enabled the document log (document properties in tab general) and adding some trace-statement, for example something like:
for each vFile in ...
trace '$(vFile)';
...
next
you will find the files which are different as expected.
- Marcus
Dear Andrejs,
The problem is displaying because something was changed on your xlsx file.
Just try to recreate a new connection through the wizard on your load script then fix the code in the original Qlik App.
The following are the possible causes behind Excel 'external table is not in the expected format’ error.
To fix this Excel error you try the fixes mentioned in this helpful post.
SOURCE: http://www.repairmsexcel.com/blog/excel-external-table-is-not-in-the-expected-format