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.
Gillian Leo 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.