Redirect all Excel pivot tables to a different data source
Posted on 2011-09-03
I am resubmitting this in hope that I get better advice this time.
I have a workbook with 30 pivot tables, each pulling data from SQL data views. I need to redirect all 30 tables to a different SQL database. I know how to do this one pivot table at a time, but is there a way to redirect all of them at once, possibly by using VB? I need to change the connection strings and the names of the database in the queries. Thank you for any advice.