Cannot open xlsx file format

[clarisa]

Hello everyone,

I am trying to open a .xlsx file and I get the following error:



After investigating further, I noticed that the file "xl/_rels/workbook.xml.rels" is present within the extracted contents of the file. 



Interestingly, when I manually perform a "save as" operation on the file, I am able to open it without any issues. However, this is not a sustainable solution for me as the file is downloaded and updated on a daily basis.

If any of you have encountered a similar problem or have insights that could potentially help me, I would greatly appreciate your assistance. Any advice, suggestions, or workarounds you can provide would be incredibly valuable to me.

Thanks in advance 🙂

[marcus_sommer · Accepted solution]

The file-format of the file isn't close enough to specified standards of ooxml - at least within a more strict sense. This is probably caused from the source which isn't a desktop Excel else another tool with some variance by features or the age of the used libraries.

So the best would be to adjust the Export tool/routines or switching to another output-format, for example in csv. If this isn't possible there would be probably only workarounds like the mentioned "save as" - whereby such tasks could be automated by any macros.

[clarisa]

Thanks for you help, Marcus! As you pointed out, the file is not being generated in a desktop Excel application.
I think the message from Qlik was not clear enough, so I appreciate your clarification.