Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Contributor III

Excel export error


My user is getting the below error when they try to export data to excel. The data is 150 columns x 200000 rows and some large text columns.  The resulting file is approx 78MB.  How to fix this error?

"you have reached the size limitation of the export process. please reduce the number of values to export or change the settings."

In help it is written:

"The default maximum number of rows and columns in the Excel export file is:

  • 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
  • 16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent."

Community Browser