When to Use Large Data Mode
There is no precise limit as to when to start using Large Data mode. This depends on multiple factors:
PPM Server hardware configuration
PPM Server hardware configuration impacts on template rendering time.
PPM Server heap memory
More memory means that larger amount of data can be inserted in Template mode without facing memory issues.
Excel template complexity
If you use lots of formatting on the data you insert in the template, this will result in a much bigger XLSX file and more memory usage.
Overall, tests show that Large Data mode should be considered when more than 10,000 rows of data can be inserted in the Excel report.