How to get more than 65536 records in single excel file in Cognos10

Hi Guys,

As we know excel by default supports only 65536 records in single sheet. In Excel 2007 if you want more that this the data comes in separate tabs so how to get this in a single excel ??

we could try setting the ExcelSpreadSheetSize property in rsvpproperties.xml.sample but i dont think this solves it.Excle 2007 will still show it in separates tabs.

Working on this will update once i find a solution