Hi - i have a pivot table connected via odbc to a foxpro table. In excel
2003 I used to be able to use vb to change the connection string and thus
point to a different table. I'm now using excel 2007 and although the vb
statement says

..Connection = "ODBC;DSN=Visual
FoxPro Tables;UID=;;SourceDB=w:\FoxSys\Foxdos\This\Stk\rh s;
SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Co llate=Machine;
Null=Yes;Deleted=Yes;""


the sourcedb doesn't change from its existing ....\this\stk\nav. Am I
missing something uisng new connection strings

Thanks

Max