Pivot table - ODBC change

in a pivot table, i set up the ODBC1 to connect to a test server. If later, i
want to promote to production server which has a new ODBC2. Now, because of
the ODBC change, i have to rebuild the pivot table from scratch. my question
is if there is any way in Pivot table itself i can change to the new ODBC2? I
can't keep the same name here ODBC1, but change database server for ODBC1,
since the ODBC1 and ODBC2 have been configured in many PCs...