I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just refresh the ones created using excel 2003.
Software/Hardware used:
ASKED:
December 23, 2008 3:33 PM
UPDATED:
March 5, 2010 9:53 PM
Did you ever get an answer to this question? I am having the same problem.