topic Excel export error in App Development https://community.qlik.com/t5/App-Development/Excel-export-error/m-p/9336#M711 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My user is getting the below error when they try to export data to excel. <SPAN style="font-family: Arial, sans-serif;">The data is 150 columns x 200000 rows and some large text columns.&nbsp; The resulting file is approx 78MB.&nbsp; <SPAN style="font-family: Arial, sans-serif;">How to fix this error?</SPAN></SPAN></P><P></P><P>"you have reached the size limitation of the export process. please reduce the number of values to export or change the settings."</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">In help it is written:</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">"</SPAN>The default maximum number of rows and columns in the Excel export file is:</P><UL><LI>1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.</LI><LI>16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent."</LI></UL><P></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 11 Jun 2018 16:03:38 GMT reshma_km 2018-06-11T16:03:38Z Excel export error https://community.qlik.com/t5/App-Development/Excel-export-error/m-p/9336#M711 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My user is getting the below error when they try to export data to excel. <SPAN style="font-family: Arial, sans-serif;">The data is 150 columns x 200000 rows and some large text columns.&nbsp; The resulting file is approx 78MB.&nbsp; <SPAN style="font-family: Arial, sans-serif;">How to fix this error?</SPAN></SPAN></P><P></P><P>"you have reached the size limitation of the export process. please reduce the number of values to export or change the settings."</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">In help it is written:</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">"</SPAN>The default maximum number of rows and columns in the Excel export file is:</P><UL><LI>1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.</LI><LI>16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent."</LI></UL><P></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 11 Jun 2018 16:03:38 GMT https://community.qlik.com/t5/App-Development/Excel-export-error/m-p/9336#M711 reshma_km 2018-06-11T16:03:38Z