Hello,

I have many Excel workbooks that have a connection to a cloud based SQL server database. The IP address has since changed and I need to go into all of the workbooks and change the connection.

My question is: Going forward, is there a way to store the connection information in one spot so I don't have to go into all workbooks to change the connection information? I wasn't sure what the best practice for this was... any advice is welcome.

Thank you!
Chrissy