change the ODBC data source of a pivot table

[JohnH]

I created a pivot table using a test version of a sql database (odbc) I want
to change the data sorce of the pivot table to my production database. I
can't figure out how to do that. I'm using Excel 2003 and SQL 2000

Thanks
John