R Rene Mar 25, 2010 #1 In XL 2003 you could select another pivot table as source data for a second pivot table. How do you do this for XL 2007?
In XL 2003 you could select another pivot table as source data for a second pivot table. How do you do this for XL 2007?
E Eduardo Mar 25, 2010 #2 Hi, Highlight the pivot table, press CTRL + C, go to where you want the new Pivot T, press CTRL V, change parameters, when you update the other PT it will update this one
Hi, Highlight the pivot table, press CTRL + C, go to where you want the new Pivot T, press CTRL V, change parameters, when you update the other PT it will update this one
A Ashish Mathur Mar 26, 2010 #3 Hi, Press Alt+D+P and there you will see the option to select another pivot table
