You can view reports in different Excel formats, depending on the version of Excel used in your company.
You can also view output in HTML, PDF, CSV, and XML format.
Excel format supports up to 65,536 rows on a single worksheet. When a report exceeds this limit, the data appears on multiple worksheets in the Excel workbook.
The full date format does not always appear correctly in Microsoft Excel 2000 if it is on a system with a regional setting other than English. This does not occur with Microsoft Excel 2002 or 2003 versions. To fix this, specify the desired date format in Excel.
Other limitations exist when producing reports in Microsoft Excel format. For more information about these limitations, see Limitations When Producing Reports in Microsoft Excel Format.
Open the analysis that you want in Analysis Studio.
From the Run menu, click Run report (Excel).
The report opens in a new window.
Tip: To view the report in another Excel format, click
the Excel button 
in Cognos
Viewer and select the desired format.
