"Export to Microsoft Excel" in Bex Web

[Former Member]

Hi Experts,

I am refreshing report in Bex web and trying to save in Excel format.

I am hitting on " Export to Microsoft Excel" button.

It works fine with 65 pages report , but fails to export for report with 265+ pages.

This report has 7+ columns.

We are using MS 2007 version and BI 7.0

Wanted to check if there are limitations or if any SAP NOTES or PATCHES would help me.

I quick reply would of great help to me.

Thanking in advance.

VS8VIV

[former_member225306 · Accepted solution]

Hi,

unfortunately SAP still limitate exporting to EXcel files no more

than 65,536 rows , currently there is no solution available for this

issue.

Please check note 1040454 and its restrictions from the .NET

environment, leading to the limitation of 750.000 cells. If one

considers the currently existing limitation of 65536 rows, this

would mean something around 11 columns. Even when more rows are

supported, the maximum number of cells that the .Net process can

handle would not increase.

1178857 Additional information: Export to Excel functions.

For huge queries SAP offers Open Hub as a 3rd party tool. Please refer

to the following link for more information

about this:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/504797dc-9467-2a10-52ba-acd35244cd39

Regards,

Venkat

[Former Member]

Hi,

Please check the sap note 700206 for the excel export limitation .

Regards,

Amit

[Former Member]

Thanks, but SAP NOTE says "Excel export gives error "List object is too large to be exported" when

a large list object is exported. This message comes only on usage of

function module XXL_FULL_API for Export to Excel functionality."

I am not using any function module XXL_FULL_API for Export to Excel functionality.

Just hitting on "Export to Microsoft Excel" button in Bex web.

Can you please clarify.

Thanks

VS8VIV