limitation rows excel

[Former Member]

Hi all,

It's possible to exceed the limit of 65536 rows by VBA code?

Thank you

Gianmarco

[Former Member]

This limit is due to Excel, not to BW.

On the other hand, consider the readibility of a report which contains more than 65000 lines ... I would say BW is not the good tool, or the report is not well defined by the user.

It's usually the case when you migrate from an "old" reporting tool to a new one : People do want to have the same report as the previous, instead of rethinking the analysis.

[Former Member]

I must use BW excel report, I can't use BW WEB interface.

By VBA code can I split bex-layout in two sheet?

Thank you a lot

Gianmarco

[Former Member]

No, because when the refresh macro is run, the data are already in the Excel sheet.

What you could do is to insert 2 queries, and to limit both mutually exclusive, to have first part of the query on a sheet, and second part on the next.

[Former Member]

The memory overhead on this is going to be massive to an end user PC - as my learned collegue earlier suggests - are you really sure?

If it were me - I would broadcast andxmls csv file to the user and let them deal with it

Even then that is fraught with problems as the SAP email outbox settings may block the size of the file going out in SOSG

[Former Member]

'^v' Agree ...

Edited by: Frédéric GAUTHIER on Sep 16, 2008 4:32 PM