5 AO Workbooks to be combined into one workbook

[former_member485169]

Hello All,

I have 5 AO workbooks. For example, each workbook contains like 6-8 tabs - reports + bex queries.

Now I want to combine all the workbooks into one workbook with about 30 tabs in one workbook.

Can you tell me how to do it? Is there any way to merge all 4 workbooks in less time?

Thanks!!

[former_member485169]

Each notebook has 2-3 bex queries and then reports based on that queries. So I want to combine or merge all 5 works into one excel sheet with all the tabs in it. Can you please suggest the best approach to do it? Thanks in advance .

[shivakrishnaj]

Hi Senthil,
Try this option.
First, take a backup of these 5 workbooks
Open all 5 workbooks & Decide in which workbook you want to merge the workbooks.
Select sheet & right click -->select Move or copy option
Here Check to create copy option
To book drop-down selection select which workbook you want to merge this sheet & sheet order.

Let me know is this solution fix your problem.

Thanks & Regards,
Shiva

[former_member485169]

I tried that - Move/COPY . It copied all the works to one.

The issue is all the workbooks merged with the base workbook don't show the query as a data source. I think I need to insert the query as a data source. I fear that the report formatting might go away if I do it. There are too many excel formulas in the report.

Any suggestions?

Again thanks for the reply and appreciate it.

[former_member485169]

when I insert the query as a data source then all the formula references are gone. I need to copy the formula line by line again referring to the query. Is there any solution to avoid this line-by-line copy of the formula?

[shivakrishnaj]

When we migrate with this option then data can be migrated but cell references will change.
As per my knowledge their is no such option to copy line by line formulas.