I have a worksheet that has 25 pivot tables and I have to recreate
this report every few months with a new data set. I would like to be
able to reassign the ODBC driver with a macro but when i record the
macro it stops recording when i enter the microsoft query editor. Does
anyone have a macro that would let me reassign all these pivot tables
at once rather than replacing them manually?

Right now I chance the the table the pivot table is reading from
withing the same driver. If it helps I could the table name the same
create a new driver.

Thanks in advance,

Paul Lambson