Home Discussions Questions & Answers Handling Large Data Volume Output in Excel

Handling Large Data Volume Output in Excel

Avatar photoCustomer October 27, 2023 at 9:47 pm

If I leave the ‘Blitz Report Row Limit’ profile unset (‘no limit’), what is the default behavior when a report exceeds the standard Excel row limit?

Viewing 4 reply threads
  • Author
    Replies
    • Support October 28, 2023 at 2:36 am  

      If the report runs without an explicit limit, the data will overflow to additional sheets at every 1,048,575 rows for XLSX output format.

    • Avatar photoCustomer October 28, 2023 at 7:22 pm  

      What is the default limit for rows returned by the report itself?

    • Support October 30, 2023 at 5:01 am  

      The default limit is ‘no limit’.

    • Avatar photoCustomer October 31, 2023 at 4:38 am  

      Can I set a lower sheet row limit if I have many columns?

    • Support November 1, 2023 at 4:50 am  

      Yes, you can set the ‘Blitz Report XLSX Sheet Row Limit’ to a smaller value if you need to avoid the 4G size limit.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: