Qlik Sense on Windows: Cannot open an excel file exported with table formatting

[Nao_Baba]

When you download an object with table formatting, the downloaded file cannot be opened in Excel, and you will see this kind of error:

Excel cannot open the file XXX.xlsx 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.

 

Resolution

Upgrade the Qlik Sense version to May 2023 or higher.

For more info, see Qlik Sense on Windows May 2023 Release Note 

Fix Version:

Qlik Sense Enterprise on Windows May 2023 and higher

Cause

Product Defect ID: QB-17850

Environment

Qlik Sense Enterprise on Windows Feb 2023 and earlier