Thread: change the ODBC data source of a pivot table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnH JohnH is offline
external usenet poster
  
Posts: 27
Default 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
Reply With QuoteReply With Quote