This is an EXCEL 2007 / MS Query question. When I have queried another sheet in the same excel file, and I want to edit that query sometime later, I get an error window "ODBC Excel Driver Login Failed" and after that I also get "Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt." What can I do to fix this issue. It seems to refresh fine, but I cannot get into the query to make any changes I want.
Bookmarks