0 Replies Latest reply: Jun 11, 2018 12:03 PM by reshma k m RSS

    Excel export error

    reshma k m

      Hi,

       

      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."