Sorry... forgot to mention one thing, make sure you click on the pivot table
you want to change first!

--
Regards,
db


"db" wrote:

Go to Data-Pivot Table and PivotChart Report.... and select the back button
to change the reference.
--
Regards,
db


"dipsy" wrote:

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.