MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot tables - modifying source data

Posted by Brent Williams on September 13, 2001 6:09 PM

Is it possible to change the data source of a pivot table to another pivot table after you have already created it.

The dialog box to refer to another pivot table seems to come only while creating it, not after.


Posted by Mark W. on September 14, 2001 8:10 AM

Yes, simply press the PivotTable Wizard's "<Back"
button 'til you get to Step 1 of 3 of the wizard.
From there you can choose "Another PivotTable..."
as the source of your data.