Change IP address in Excel Sheet for SQL sever

[Patrick]

We have change the IP address of our SQL Sever from
192.168.0.xxx to 192.168.0.4. This results in big problems
as all our Excel Sheets with Pivots and SQL Queries in the
have stopped working.

Cause is that instead of using name we have used IP
address in our ODBC set-up so the Excel file has the IP
insted of the name of the SQL server.

Now, one way to solve this is to save every sheet as XML
and then change the adress, then import it and save it as
an xls file again - losing graphs etc.

Is there anyone that have an alternate solution to this
problem and I will be eternaly greatful - we have a s-load
of spreadsheets with this problem.

Best regards,
Patick Bjurquist

 

[sdfsdfsadf]

sdfsfsfd