Report KE30 Transfer to Excel not possible too much data

[Former Member]

Hi:

We have a report in KE30 for PA analysis and works properly. Now we have done a copy of this report with more data. We are having problems whe we want to export it to XXL. We get next message:

========

Transfer to Excel not possible too much data

Message no. KH 429

You have transferred so much data that Excel cannot display it all. You

either transferred too many rows or too many columns.

rocedure

Reduce the number of rows or columns in the report. One way to do this

is to deactivate certain rows or columns temporarily. You do not have to

delete the rows or columns, since the system only transfers the active

ones to Excel.

You can, however, also makes changes in the form as well.

You can use 256 as a rough guideline for the number of columns and 16000

for the number of rows. This figures only roughly describe the size,however, since administrative information is stored as well.

=========

Do you konw how we can solve it? We need all lines form report so we can not reduce lines.

Thank's in advance.

Best regards.

[waman_shirwaicar · Accepted solution]

Hi,

When you export lists to XXL, there is a technical limit for the number of lines and columns. I regret but there is a maximum number of rows and lines (please also see the long text of error message KH429 and the online documentation 'CA-Drilldown reporting' -> 'Save, Print, Export' > 'Export' -> 'Export report to XXL').

So, please reduce the number of rows or columns in the report.

One way to do this is to deactivate certain rows or columns temporarily. You do not have to delete the rows or columns, since the system only transfers the active lines to Excel.

You can, however, also makes changes in the form as well.

This is a restriction in the XXL interface that we cannot change in the application. Therefore, I can only recommend you to make the list smaller before exporting it (ex. by additional restrictions or navigation).

The reasons are described in the note 66981.

regards

Waman

[Former Member · Accepted solution]

Thank's a lot.

Solved.

[Former Member]

Migrating to Excel 2010 would probably solve your problem.

Otherwise, as you say you need all the lines and the number of lines is higher than what your excel version supports, I fear we cannot help you overcome this limitation.