Supporting large worksheets in Microsoft Excel

Administrators provide support to users that need to use large Microsoft Excel 2007 worksheets by setting the advanced server property, RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET, to a value of true. This enables the large worksheets. You must set this property for the ReportService and the BatchReportService.

When RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET is enabled the large worksheet property supports worksheets up to 1 048 576 rows and the following two parameters:
  • Use RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS to specify the number of rows to output before moving to a new worksheet.
  • Use RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE to adjust the internal memory fragment size, in rows, that the IBM® Cognos® Business Intelligence server generates before flushing to a disk. If this value is not specified, then the default value is approximately 45 000 rows. You can use this property when there an issue generating reports with the default value, such as running out of memory. In this situation, you may be required to lower the value to allow the report to run successfully.
Parent topic: Server Administration