How easy is it to change the server odbc details for excel
 

Hi Everyone

I have a slight problem and wondered if anyone had seen anything similar.

We had to change the network IP address of the server that people connect to
with odbc in excel. How easy is it to change the excel details. At present I
have to wait until it times out before I can alter the details.

Is there an easier way?

Thanks

Bryan