How to change old data source reference from copied pivot table

's Computer Specifications

Hi All,

I need to change the old datasource references from copied sheets having
pivot tables and charts.

But i am not getting any way to find solution by any means.

Kindly help me on this regards.

Thanks,
arun

's Computer Specifications

Arun,

to change the datasource of a pivottable, use the PivotTable-Assistant.

Regards,
Dominik.

arun schrieb:
> Hi All,
>
> I need to change the old datasource references from copied sheets having
> pivot tables and charts.
>
> But i am not getting any way to find solution by any means.
>
> Kindly help me on this regards.
>
> Thanks,
> arun

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data source reference is not valid in pivot table wizard	Oliver Marshall	Microsoft Excel Discussion	4	22nd Mar 2011 11:57 PM
what does "data source reference is not valid' in Pivot table	roshan	Microsoft Excel New Users	0	20th Aug 2009 03:18 AM
How can I change the source data reference to another pivot table?	apss40	Microsoft Excel Misc	2	25th Jun 2009 02:41 PM
how to change old data source reference from copied pivot tables	arun	Microsoft Excel Misc	2	20th May 2009 01:13 PM
how to change old data source reference from copied pivot tables	arun	Microsoft Excel Misc	0	20th May 2009 08:06 AM