SQL Server Performance Forum – Threads Archive
Excel-SQL data refresh issueI am using an Excel speadsheet that uses a sql query to populate. Recently the SQL server I connected to changed to new hardware and a new name. I redid all my odbc datasources, but I still cannot refresh the data in excel. Is there a setting within Excel that I need to examine to be able to connect to the new server and refresh the data? I verified that the refresh does work when I restarted the old sql server. Thanks for the help!
Have you tested those modified ODBC connections against this new server.
Running a PROFILER during this operation may help you to assess. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Yes… I ended up just copying the queries and deleting them within excel and then recreating them and they worked out ok. . THanks!