SSRS, exporting separate EXCEL sheet for each group by element

Question

I am working on SSRS. I have a table having a group by column . And I used page break. so its exporting separate tab for each group element within same EXCEL. But I want to export separate EXCEL sheet for each group by element.

Answer 1

I do this on a few reports and it worked for me.

Try this - Method