Hi DB:
Thanks for the suggestion - however, when u go back and change reference you
loose the set up of the pivot table. I want to keep the set up and change
the source for the named range of the pivot table.
Thanks.
"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.
|