I had setup several complex link in excel 2003 to MS-SQL 2003. The link were setup using ODBC DSN.
The company decided to upgrade and move SQL server to SQL 2008 with new SQL server name.
I change ODBC DSN to link to the new server and my financial applicaiton works fine. The problem is with Excel. It gives error that SQL server dose not exists. It seems that Excel setup is looking for old server. It will not allow me to even Edit the query to change the link to new server.
I have several years of files that needs to be updated. Is there a location where i can find the link outside of excel to oepn and change the link?
Microsoft SQL ServerMicrosoft ApplicationsMicrosoft Excel