Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


Hi all,

I have a problem with a large workbook. This workbook consists of average 60 queries with large deferent constant structures. The workbook is made in Exel 2003 and in this version of Exel max count of rows are 65535. But the sheet SAPBEXqueries should contain more rows. I can't change the number of queries and their structures.

Pls, help me.

Former Member
Former Member replied


Trying to review 64k + data rows is almost impossible so I am guessing you need to get a summary view. You can create a pivot table directly in Excel that pulls its data from the BW Info Area. I know I have a document on it somewhere so will have a look for it.

Pivot tables will let you get at the same records in your query and present a summary of the data which may be worth looking at.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question