Configuring report and batch report services to use large worksheets

Set the advanced server property, RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET, to a value of true to enable large worksheets. You must set this property for the ReportService and the BatchReportService.

Before you begin

You must have the required permissions to access IBM Cognos Administration Secured Functions and Features.

Procedure

  1. Launch, IBM Cognos Administration.
  2. On the Status tab, click System.
  3. In the upper-left corner of the Scorecard pane, click the arrow to view the Change view menu.

    Click Services, and then click (All).

  4. Click the arrow for the Actions menu next to a Report or Batch report and click Set properties.
  5. Click the Settings tab.
  6. Click Edit next to Advanced Settings.
  7. Select Override the settings acquired from the parent entry.
  8. In the Parameter column, type a parameter name. For example, type RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET.
  9. In the Value column, type the setting that you want to use. For example, type true.
  10. Click OK.
  11. On the Set properties page, click OK.
Parent topic: Supporting large worksheets in Microsoft Excel