Recommendation - use page breaks to improve performance of large reports

Microsoft Excel has no default page size. As a result, if you have a large report, Excel tries to render it as a single worksheet.

If you do not specify page breaks for a report that returns a large amount of data, some report formats try to render a report as a single page.

When importing report elements, you can use the Insert breaks between report pages option in the Import Content wizard.

In general, using page breaks improves the performance of users accessing the report because they can view the first page while the rest of the report is being rendered.