Changing data source in a pivot
 

I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know how?

Changing data source in a pivot
 

In the pivot table wizard, click the Back button.

"John R" <John wrote in message
...
I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know how?

Changing data source in a pivot
 

Hi

In addition to Bob's reply, if you are dealing with connections to an
External data source, Ron Coderre has written a nice utility which can
be found at Debra Dalgleish's site
http://www.contextures.com/xlPivotPl...ml#SrcSettings

--
Regards

Roger Govier


"John R" <John wrote in message
...
I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know
how?

Changing data source in a pivot
 

Thanks, this is perfect!

"Roger Govier" wrote:

Hi

In addition to Bob's reply, if you are dealing with connections to an
External data source, Ron Coderre has written a nice utility which can
be found at Debra Dalgleish's site
http://www.contextures.com/xlPivotPl...ml#SrcSettings

--
Regards

Roger Govier


"John R" <John wrote in message
...
I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know
how?

Changing data source in a pivot
 

In Office 2007 click on the data tab.
On the Connections box click properties.
Go to the Definition Tab
Click on the Edit Query Button

This might help.



"John R" wrote:

I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know how?