Home › Discussions › Questions & Answers › Handling Large Data Volume Output in Excel
Customer · · Questions & Answers · 5 replies
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?
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.
What is the default limit for rows returned by the report itself?
The default limit is ‘no limit’.
Can I set a lower sheet row limit if I have many columns?
Yes, you can set the ‘Blitz Report XLSX Sheet Row Limit’ to a smaller value if you need to avoid the 4G size limit.
Sign in with LinkedIn or Google to take part.
