edit data connection properties

[karenj900]

I use Excel to connect to a datasource for a program that used to use mapped
drives and a different method to validate user and password. In the new
version, only unc paths are used to the data and the user name and password
are now using .net 2.0 components to validate. My existing worksheets will no
longer refresh though I can create new connections to the data. Is there any
way to update the connections in the worksheet without having to rebuild the
entire thing?

kj

 

[Joel]

What I did last month for somebody was to write a macro which retrieved the
SQL statements from the query. Then the person used the SQL editor and
pasted the retrieved SQL statments into a new Query. You can't just can't
change the Connection.