External Data Query - ODBC password changed

  • Thread starter Thread starter TomD
  • Start date Start date
T

TomD

I have a worksheet that was originally set up with the Get
External Data-->New Database Query menu option, I used
ODBC data sources and entered my user id and password at
the time.
Since then, I use the Refresh Data menu option monthly to
get new data. The password is embedded in the worksheet
so I don't need to enter it a second time.
However, I just changed my password on the database server
and now Refresh Data gives me an ODBC error (Attempt to
connect to the server failed.)
I can't find a way to update the worksheet with the new
password. Help please!
 
-----Original Message-----
I have a worksheet that was originally set up with the Get
External Data-->New Database Query menu option, I used
ODBC data sources and entered my user id and password at
the time.
Since then, I use the Refresh Data menu option monthly to
get new data. The password is embedded in the worksheet
so I don't need to enter it a second time.
However, I just changed my password on the database server
and now Refresh Data gives me an ODBC error (Attempt to
connect to the server failed.)
I can't find a way to update the worksheet with the new
password. Help please!
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External Data Refresh Issues 0
Switching ODBC sources in Excel 2007 1
External Data Toolbar permanently greyed out. 7
ODBC Issue with Pivot Table 1
Changing ODBC data source for a query embedded in Excel 4
Get External Data grayed out 10
ODBC Error Message 1
External Data Query 3

Back
Top