I have an excel worksheet that is pulling data from our development sql server. Just a straight select the table from the drop down and dump all the data into excel.
If I go into he connection properties and change the server name and hit refresh nothing seems to happen. The data is still the development data.
No permission or access denied errors I seems like excel is no honoring the edited connection string.
I re-opened the connection properties an the production server name is still in the connection string.
I am posting this for our Excel Person. There is no SQL per se. He just chooses... Data->From Other Sources->From SQL Server... Enters the Server selects the Database and then the Table and that is it.
From there we went to ... Data->Connections...Selected the connection. Clicked 'Properties' and then edited the connection string, replacing the development server name with the production server name. Clicked OK and then did a Refresh. But it still pulled from development.
I am a DBA and barely know how to spell Excel :-) Since it seems to be an issue with a connection string, it got dumped in my lap.