Editing IP address in Excel ODBC link

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Guys, hope someone can help me.

Due to a recent forced IP migration our AS400 server has changed its IP address.
We have a number of Spreadsheets with ODBC links to it, when I refresh the data a dialogue asks for a username and password, but the box with the IP address is greyed out not allowing me to change it.

The IP address is hardcoded in the spread***, I can see it with a hex editor, but has an extra digit, 11 instead of 10, (I cant open the spread*** If I change it in hex).

When I try to edit the query It insists on running it first, then times out trying to connect to the old IP address.

Anybody have any ideas??


**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
.

Quantcast