D
Dave Mc
Sorry for the lack of knowledge. I have some spreadsheets which pull data
from sql database thru an ODBC connection. Since upgrading to 2007, when I
"Edit query" on some of these spreadsheets, it starts to connect then I get a
warning saying that it is changing to database context XXX. The database it
is changing to is the one I want but the warning I get only lets me click on
OK, but the query window does not open. I have seen some documents that this
say this is just a warning but when it is reported, it stops the script from
completing. I don't have a clue what to do about this. It works OK on Excel
2003.
from sql database thru an ODBC connection. Since upgrading to 2007, when I
"Edit query" on some of these spreadsheets, it starts to connect then I get a
warning saying that it is changing to database context XXX. The database it
is changing to is the one I want but the warning I get only lets me click on
OK, but the query window does not open. I have seen some documents that this
say this is just a warning but when it is reported, it stops the script from
completing. I don't have a clue what to do about this. It works OK on Excel
2003.