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?