ExcelBanter - change the ODBC data source of a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change the ODBC data source of a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/105338-change-odbc-data-source-pivot-table.html)

JohnH

change the ODBC data source of a pivot table

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

All times are GMT +1. The time now is 09:32 AM.