what is the diff b/w excel 2000 and excel 2002 sheets if any
body know this answer plz tell me

Answers were Sorted based on User's Feedback



what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me..

Answer / haribhm

In Excel 2000, data is shown in a single excel sheet.If the
cognos report have multiple report pages to be displayed,
excel 2000 is not a right choice.

If the cognos report have multilpe report pages to be
displayed, excel 2002 is the correct choice as it can show
multiple report pages output in multiple worksheets in a
single excel file.

Is This Answer Correct ?    3 Yes 2 No

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me..

Answer / prashant

There are multiple versions of Excel output for backwards
compatibility reasons.

CSV - raw data, no formatting, only possible with single
Query reports. Delivered in email as a .CSV file.

Excel 2000 Single Sheet - all report pages rendered to one
Excel 2000 worksheet. Delivered in email as a .HTML file.

Excel 2002/2003 - each report page is rendered to its own
Excel 2002/2003 worksheet, in a single Excel 2002/2003
workbook. Delivered in email as a .MHT file.

So the difference will be type of extension of the the file
and the way the report O/P gets generated.

Is This Answer Correct ?    0 Yes 0 No

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me..

Answer / manju

Excel 2000 having limitation upto 65,536 rows and 236
columns.
Excel 2002 doesnot have limitation.

Is This Answer Correct ?    2 Yes 4 No

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me..

Answer / srinivas naidu

cognos 8 can produce reports in excel foramt.three options
are available:
EXCEL 2000 single sheet:in this we can see the data earlier
than 2002.

EXCEL 2000 :You can view the data Microsoft EXCEL versions
2002 and later
EXCEL 2002:You can view the data Microsoft EXCEL versions
2002 and later

Is This Answer Correct ?    2 Yes 9 No

Post New Answer

More Cognos Interview Questions

How to hide the prompts

4 Answers  


How is cognos model organization works?

0 Answers  


How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?

2 Answers   Wipro,


please tell me architecture of the cognos8?

4 Answers   IBM, TCS,


How many fact tables and dimension tables in your project?

3 Answers   IBM,






what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

0 Answers   Cognos, IBM,


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  


What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,


What is the difference between filter & Condition?

4 Answers   IBM, Polaris, TCS,


Can we create reports using OLTP database?How?

3 Answers  


What are the different type of securities can we apply in framework manager?

1 Answers  


Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 Answers  


Categories