Excel output

[shri]

hello...

I have report which outputs more than 65,000 rows, how to split the excel output into different sheets. for example if we have 100,000 rows split them as 20,000 in each sheet like sheet1,sheet2,sheet3,sheet4, sheet5...


thanks for your help.
cheers

[billylodz]

Page set - and output Excel 2002

[shri]

Hi Billylodg, thanks for reply. I understood the excel 2002 part, but i couldn't get page set part.  do i have to include page set in the report..? please explain. thanks.