Can you please tell me the limitation of Excel file when
exporting from report to Excel? I can export to HTML and
PDF but I can't export to Excel. The report is more than
13000 rows. When exporting to Excel, system can view it.
After that, I save the report to an Excel file. The size of
Excel file is more than 11 MB. But I can't view this file
by Excel. Please help me to solve this problem. Thanks!



Can you please tell me the limitation of Excel file when exporting from report to Excel? I can exp..

Answer / suresh

The limitaion for Excel is 65000 rows if U are using any
version Prior to Cognos 8.3.If its C8.3,then in Excel 2007
format alll these estrictions are overcome.
Please check ur IE settings too....

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Cognos Interview Questions

Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.

2 Answers  


1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?

1 Answers  


In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,


6. Which of them will increase the performance?

1 Answers  


What is the size of database for you project?

0 Answers   Accenture,






This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,

0 Answers  


Can you define fan trap?

0 Answers  


Can i apply drill through on chart in report studio?

4 Answers   TCS,


What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers  


what is stitch query in reportnet?

0 Answers   IBM,


What is defined as catalog and types of catalogs in Cognos?

0 Answers  


Explain about Parametermap?

1 Answers  


Categories