Hello,

I have a spreadsheet with an embedded query pointing to an access database (using an ODBC datasource). I THOUGHT that I could move the datasource's file, update the ODBC datasource and the spreadsheet would work. However, the location of the MDB appears to be embedded in Excel. When I try to modify the query, it says it can't be modified. Is there a way to adjust the query in the spreadsheet to point to a new MDB??? I have done 30 spreadsheets this way!

Thanks!

Pat