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...
