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

Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

0 Answers  


what is a prompt value in report studio and variables ?

0 Answers  


how u create cubes in ur project

2 Answers   IBM,


difference between impromptu and cognos8

0 Answers   HCL,


----------------------Diff b/w MOLAP and ROLAP?

4 Answers   Bank Of America,






What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?

1 Answers  


if there are list,crosstab,chart how can you apply a single filter to all object?

3 Answers   IBM, Syntel,


How to join multiple db in catalog?

0 Answers  


Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,


How applying "Level Span" in Cognos 8.3?

1 Answers  


Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,


Can you define folder?

0 Answers  


Categories