Solved- Collapsing Groups - How?

[arimmer]

I have successfully added grouping to my report by setting the outline levels on rows, but can't get it to open in MS Excel with the groups collapsed.

If I collapse the groups within MS Excel and save and close the spreadsheet and re-open it, the groups stay collapsed, but I haven't yet found what is allowing this. (I am setting the collapsed and hidden attributes on the row)

I'll keep investigating, but thought I'd ask here if anyone else knows how to solve this problem?

[arimmer]

Problem solved.

As well as setting the maximum outline level within the sheet in the SheetFormatPr element, it is also necessary to set the default row height in the same element.

[jason]

Thanks for letting us know