Hello there!
I have a workbook that pulls data from a SQL Server 2000 database using several different queries for different parts of the workbook. I built the queries using the "New Data Query" option in Excel and I have the query properties set to refresh on open.
Everything works beautifully - my only problem now is that we are ready to run it against production data, which is on a different server, and I can't figure out how to change the server name in the query. I guess that is stored in the actual workbook.
Does anyone know a way to do this, short of deleting and re-creating the queries?
Thanks for your help!
Linda
I have a workbook that pulls data from a SQL Server 2000 database using several different queries for different parts of the workbook. I built the queries using the "New Data Query" option in Excel and I have the query properties set to refresh on open.
Everything works beautifully - my only problem now is that we are ready to run it against production data, which is on a different server, and I can't figure out how to change the server name in the query. I guess that is stored in the actual workbook.
Does anyone know a way to do this, short of deleting and re-creating the queries?
Thanks for your help!
Linda
