Edit ODBC connection information for a work sheet

[Per]

Hi,

I have made an Excel document which imports data from an DB2 database
through a ODBC connection.

When i send this document to a collauge that have configured the ODBC
connection in a different way than i have done,it don't works. The
thing that is different in the configuration is the naming.

Is there a way where you can locate the ODBC name that the query is
looking for in the excel sheet and change it so it matches my collauges
ODBC connection?

Best regards

/Per

 

[aaron.kempf]

yeah screw excel in the mouth

use a database-- or a reporting tool like Access or Crystal Reports.

Excel is a disease