Excel is exporting to multiple sheets

[Mfg]

Hi All,

Excel sheet is getting devided after 64999 rows! :-\ I am getting 4 sheets, but I need whole output in a single sheet.
should i set some kind of property? do excel support only 65000 rows per sheet?
is there any workaround for this?

My report configuration:

List No of rows per page: (Default, nothing specified)
List Pagination: Allow content to break across pages (Unchecked)
                         Allow Horizontal Pagination (Unchecked)
Report Properties: Group repeating cells when exporting to excel (Unchecked)

Any help will be appreciated.

Thanks in advance

[BigChris]

I think that's a fixed number for the export.

On a more general note, what is the user expecting to do with roughly a quarter of a million rows of data?!?

[Lynn]

Hi All,

Excel sheet is getting devided after 64999 rows! :-\ I am getting 4 sheets, but I need whole output in a single sheet.
should i set some kind of property? do excel support only 65000 rows per sheet?
is there any workaround for this?

My report configuration:

List No of rows per page: (Default, nothing specified)
List Pagination: Allow content to break across pages (Unchecked)
                         Allow Horizontal Pagination (Unchecked)
Report Properties: Group repeating cells when exporting to excel (Unchecked)

Any help will be appreciated.

Thanks in advance

It is a limit set by default, but may be overridden with a change to a setting.
http://www-01.ibm.com/support/docview.wss?uid=swg21419957

Although I have to agree with BigChris about the volume of data being extracted.

[Mfg]

Hi BigChris & Lynn,

Thanks for your replies.