on 08-20-2007 6:38 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.