cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Queries in same workbook but in different sheets

Former Member
0 Kudos

Hi Gurus,

I am working on workbooks in Bex. I have around 15 queries. The requirement being :

Queries 1 to 10 -> Workbook1 Sheet1 . ( This is done and works fine)

Query 2 -> Workbook 1 Sheet 2.

Query 3 -> Workbook 1 Sheet 3.

Here when I insert query in sheet 2, the queries from sheet 1 disappears.

How to insert multiple queries in different sheets in the same workbook?

Points assured.

Regards,

Sunitha.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

open your workbook, sheet 1, select Tools->Insert Query from the bex-toolbar and following select the query 1. After that, goto sheet 2, select Tools->Insert Query.... and select query 2.....

regards

Siggi

Former Member
0 Kudos

Hi Siegfried Szameitat,

I have inserted the queries in my worksheet. My next problem being am unable to save the workbook in the template format.

Inspite of selecting PERMANENT WORKBOOK TEMPLATE option in the

settings the queries dont get executed in the format. The format is available only

for the first query in Sheet1 and for the consecutive sheets the format isn't available.

Do you have any idea regarding this?

Regards,

Sunitha.

Answers (1)

Answers (1)

Former Member
0 Kudos

answered