Business Objects Results Limit 65529

I cannot seem to find any concrete answers for this.

I have a client that has been exporting to excel a great number of rows. Recen开发者_如何学编程tly, the total number of results has hit 65529 and stayed there, even though it should be increasing.

Is there any way around the cap?

Also, we are using XI, but are about to switch over to xI 3.1. Will the cap therefore be different when we switch?

Thanks in advance.

Nope there is not.

You may want to consider CSV (Comma Separated Values) format which is unlimited and opens in excel but only the first 65529 rows.

Excel 2007 has been extended to 1 million rows. See http://visio.mvps.org/Excel_2007.htm