Workbook updating from a data source

I have inherited a workbook that contains a sheet which is updated via a data source whenever the workbook is opened. I get this message when I open the workbook:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

I want to set up the DSN on my machine, but I can't find what information Excel is using to look for the DSN. Where can I find this information (database name, dsn name, etc) in Excel?

tia,

flynn

Activate the worksheet where stand the data source.
Then go in VB editor an type the following commands in Debug Window.

To view the DSN of your Data source:
? activesheet.querytables(1).connection
To view the SQL query:
? activesheet.querytables(1).CommandText