One column to slipt to multi-column when I export report to Excel 2007

[valiant]

Dear,
   
    I'm working on Cognos 10.2. I designed one list in my report as Excel format. There are two rows in list header. When I export report to HTML or PDF, my report is good. However, when I export report to Excel 2007, my column in list sliptted to multi-column. How can I fix this issue ?  :-\


Thanks

[Grim]

This will fix that right up. Just keep in mind the Note...
http://www-01.ibm.com/support/docview.wss?uid=swg21440556

NOTE: This functionality was added to the product and is not available in all releases. Please contact Customer Support if adding this advanced setting does not produce the desired change in Excel 2007 output.

[valiant]

Hi Grim,

    I tried to work as you guide but my issue did not resolve. Are there any ideas ?

Thanks

[Grim]

Hi Grim,

    I tried to work as you guide but my issue did not resolve. Are there any ideas ?

Thanks

Yeah...

NOTE: This functionality was added to the product and is not available in all releases. Please contact Customer Support if adding this advanced setting does not produce the desired change in Excel 2007 output.