Hello,

Can I link Pivot Table 1 in WorkBook B to a pivot that exists in Workbook A?

Thanks & Cheers

Hi edver,

You cannot link to an existing pivot table, but you can link to the source
data for an existing pivot table. You can do this in two ways.

1) Create a new sheet in book A, create a pivot table in the new sheet with
data source option "Another pivot table...". Then move the new sheet to book
B - right click the sheet tab to get move or copy menu.

2) Create a new pivot table in book B. Use the external data source option.
Select Excel Sheet as the data provider and follow the prompts.

Both methods end up building a pivot table with the same data source as the
pivot in book A. Method 1 is easier if you do not have named ranges for the
original data.

Ed Ferrero
http://edferrero.m6.net/


Hello,

Can I link Pivot Table 1 in WorkBook B to a pivot that exists in Workbook
A?

Thanks & Cheers