Pivot tables, external data sources and ODBC links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet which contains 30+ pivot tables which have an external
mdb as their data source. If I change the location of the mdb then I repath
the ODBC link to the new location and manually edit the SQL code in MS Query
to change the path for each pivot table. Rather tedious. I've trawled this
site for some code to do this, but no luck so far.

A second related question. When building external data queries using MS
Query I use a pre-defined ODBC link and select that as the DSN. Now I would
have thought that if the external data source moved all I would need to do is
repath ODBC connection and all will be peachy fine, but this appears not to
be the case. The old path is being remembered somewhere.

Any help appreciated.
 
arg... yeah man im pretty much in the same boat ... all i need to do is
change the dsn system name :(

did you have any luck?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table data source 1
Can a pivot table be redirected to an external source? 1
Pivot Table Source 3
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Can't change Pivot Table data source 2
Pivot Tables- SQL Alias' & Field Lists 1
Excel Error while updating an external data source into a pivot table! 0
How do I refresh Pivot Table from an external source ? 3

Back
Top