Skip to Content

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

How to join two workbooks in one?

Hi Gurus,

Is it possible to mix two workbooks without loose BW Connection ?

I created one workbook (Called "X") and another workbook (Called "Y"). Each of them is based on the same query.

I used the function copy sheet but after the copy the sheet only have an excel-function

Could you please help finding the solution?

Thank you in advance

Cheers

Former Member
replied

Hi Gilo,

You can't mix the workbooks since they are created seperately and having different workbook IDs,but you can mix the worksheets.

If your requirement is showing the same query in different pages,then you can create a single workbook and have multiple worksheets.Each worksheet will have a same query in different formats.

You can make a copy of the worksheet without losing BW Connection and options.

To perform this,you can go to Tools->Copy Sheet of Analysis Toolbox.This will create an exact copy of worksheet to new sheet,so that you will have same query in different worksheets.I mean Sheet1 and Sheet2 will have same query.

Let me know in case of any clarifications.

Rgds,

Murali

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