Link Pivot tables between workbooks

[Former Member]

Can we Link Pivot tables between two workbooks?

I have a set of workbooks say A with BEx query data, pivot table and a pivot chart. I need to create a new workbook B and link only the pivot tables from Workbook A to workbook B. Can this be achieved ??

[Former Member · Accepted solution]

Can't you create other work sheet in the Same Work Book A ?

regards

KK

[Former Member · Accepted solution]

No I cannot. I have to similarly link several other queries to get a dashboard view with all the charts in the new workbook!!

Can we link a pivot table from one workbook to another in BEx?

If not what are the other options. My client do not use WAD!!

Thanks.

[Former Member · Accepted solution]

Are you using BI7 - Bex ?

You can insert all your quires in different worksheets and hide them, Display only the worksheet that user view's, Create references using excel formulae and generate your Dashboard.If u have different let us know , will try to help you.

KK

[Former Member · Accepted solution]

Thanks a lot, Chivukula !!!

This is what I got. I have 5 huge separate queries saved as workbooks. Each of these workbook has the query data. I created pivot table from this data and generated charts in the workbook for each of the seperate queries.

But now, I need to join or link only the charts into one workbook, to display a dashboard view. This dashboard view should have all the charts.

Since I would like to get the charts as a dynamic pivot charts, I want to link the pivot table from the exisiting workbook to the new workbook.

Can this be acheived? If not what is the other possible solution?

Thanks a lot for your help again!!!!

[Former Member · Accepted solution]

Okie, Try like this

Look the behind query's names and try Including then the work book that you are creting in 5 different worksheets., Now you have all your query's info in a single work Books.Create 6th work sheet and try generating charts as per your requirements, Once if u are hapy with the dashboard then righclick on the worksheets and hide that worksheet so that you can see only the worksheet that contains dashboard,

Which version of Bex you are currently using ?

KK

[Former Member]

?

Edited by: Raadooo on Jul 23, 2008 6:25 PM