Excel files cannot connect to SQL server after transfer of SQL database to new hardware
I have just moved our SQL server and Database to a new server and all our excel files that have been created to query the server cannot find the new data source. I am unsure where I am meant to change this setting either within the individual excel siles or as a global setting. I have added the ODBC DSN connection on my machine to connect to the new SQL server.
I am not sure where to look for 2 and 3. The server is activily working for CRM requests from another server, so the database is fine.