Right-click on a cell in the pivot table
Choose Wizard
Click the Back button
In Step 2, select a new source range
Click Finish

chetoos wrote:
Dear ALL;

i wanna Select different source data for a PivotTable , in the same
workbook ; could any one help me plz ;

Thanks in advance;


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html