Pivot Table Links
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 |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com