Open both workbooks
Right-click a cell in the pivot table, and choose PivotTable Wizard
Click the Back button
On the Window menu, choose the new source workbook
Select the range you want to use for the pivot table, and click Finish
Close the source workbook.

ashishprem wrote:
Hi,
I want some help in pivot table. I have an workbook which contains a
pivot table. I want to edit existing the pivot table.I want to change
the datasource of the pivot table to some other workbook. I don't know
how to do? Shall i edit it or make a new pivot table?
please tell me how to proceed?

Regards,
Ashish




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html