Looking for the best way to change the datasource for an existing Pivot
tables, without having to recreate the pivot table.

I tried using the wizard and backstepping however, this method does not
allow me to see the new datasource, unless I want to create a new Pivot table.

Any suggestions is greatly appreciated.
--
Karen