Pivot tables, external data sources and ODBC links
 

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?

"makrug" wrote:

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.