MS-Excel Version in IWR

[Swathi37]

Hi All,
I have a quick question.
When I try saving the cognos report as Excel in IWR, it saves it in Excel 95 format and as a result, if the report has 20,000 rows, it creates 2 sheet tabs dividing it by 16,000 in sheet1 and 4000 in sheet 2. How can we get all the rows displayed on one single sheet or try changing the Excel version from 95 to 2000. Please advice.

Thanks
Swathi

 

[DoubleD]

What version of IWR are you using? I believe Series 7 will save more records to a single worksheet. Excel 97 format I think.

Pain is stress leaving the body.

DoubleD