Hi, I have an Excel workbook that has several MS Queries that retrieve data from a Microsoft SQL server, via ODBC connection. We recently changed the server that my database resides on, so I updated my ODBC connection with the new server name. Fine, no problems there. Now when I try to refresh my queries, I get an error saying "Server rejected connection, access to database denied". So then I manually went into each .DQY file and changed the server paramater. Still the same error. The crazy part is, I can run these queries outside of my workbook. I even tried deleting the query from the workbook, and setting it back up again by doing data/get external data/run saved query. Same error. There's something behind the scenes that is still pointing to the old connection. It's making me nuts!! Has anyone run into this problem? Am I missing something obvious?
Thanks for any help!
Thanks for any help!