Have a powerpivot book with two data sources. A Table that is linked to one data source needs to be moved to now come from another data source.
Is there an easy way to change the data source and the query used? I don't want to destroy it an recreate it
Thanks