Export to separated MS Excel files per group

Hi there,

We have a crystal report which contains only main report and it has Group1 and Group 2. The report currently has a page break each Group 1 but our end users requested to generate separated Excel file per Group1 instead of printing all the records in one single Excel file.

We are using Crystal Report 2011 and checked Export Report Option and Group Expert. However, we do not see the option for this change.. Could anyone provide us some advice? Thank you in advance!

Chrissa