cannot export more than 1 million cells data in qlik sense

[faheem_momin]

We have created report for account and when we try to export into excel, it is fetching only 1millions cells data into excel.

Is there any limitation in Qlik sense for exporting the data into Excel?

Please help.

[martinpohl · Accepted solution]

it is not the limitation of sense, it is the limitation of excel.

who needs more than 1 million records in details?

[ThornOfCrowns]

If you have more than a million rows, Excel isn't the way to go, at least not just dumping the whole lot onto one sheet.

[Anonymous]

Hi Faheem,

See Microsoft limitations for excel:

[Ken_Thomas]

the original post was asking about cells, not rows.  The current November 2018 documentation does state that there is a limit to the number of cells that Sense can export to excel and it is listed as 1,000,000 cells.
https://help.qlik.com/en-US/sense-developer/November2018/apis/EngineAPI/services-GenericObject-Expor...

there are 4 other limits listed in the November 2018 docs: see above link for these details:

• number of rows and columns
• number of cells
• number of columns
• file size