Oracle Database Discussions

Currently we have a bunch of spreadsheets that we have created using a FILE DSN using the "Oracle ODBC Driver" that was used on the Oracle client 8.1.7. They work great, however they do not work if if the Oracle client has been upgraded. We would like to avoid creating new spreadsheets for the upgraded users, as upgrading all of the clients in a timely manner is not an option since a lot of the users are remote users.

There are some machines that require us to upgrade to a new version of the Oracle client(from 8.1.7 to 11g). We use an ODBC connection to bring data from Oracle tables into Excel.

When we try to refresh the query we get the following error message, it says
"[Microsoft[ODBC Driver Manger] Data source name not found and no default
driver specified"

I think it is referencing the the driver name. If you create a new file DSN
on the workstation, the FILE DSN references "Oracle in OraClient11g_home"
(in version 11g) and not" Oracle ODBC Driver"(in version 8.1.7).

Is there a way to make a general reference to the file DSN so the query
would work on workstations running either Oracle client?