Changing Name of a linked DB to excel

[thewiseguy311]

Hi all,



I would like to change the name of my databse which is currently linked to excel. I know that if I do this, then I can not refresh my data b/c excel will not be able to find the file name.

How can I adjust my excel workbook to reflect the new name of the DB once I have changed it?

Thanks in advance.


/m

[ranman256]

In the data tab, connections.
or
if you are using code to do it, enter VBE (alt-F11) and find the connection string.

[thewiseguy311]

In the data tab, connections.
or
if you are using code to do it, enter VBE (alt-F11) and find the connection string.

when i go into "existing connections," what do I do then? do i need to "browse for more" and select each connection?