Trying to connect Excel 2013 with Oracle - ORA-12154

I am trying to connect MS Excel into Oracle through Data Source ODBC
and im getting error ORA-12154

When I try to connect using ODBC it works find but
when I try to connect using TNS within Excel I get the error:
Message=ORA-12154
"could not resolve the connect identifier"

how to solve it??

here it's

To clarify Hambone's response, to connect Excel to Oracle via Oracle client driver without using TNS Names:

    1.Go to Control Panel > Administrative Tools > ODBC Data Sources
    2.Go to File DSN tab
    3.Choose Oracle driver (e.g. Oracle11gr1)
    4.Provide a name for the new data source (any name)
    5.When prompted for Service Name, enter host:port/servicename e.g. db123:1521/service123

#https://stackoverflow.com/questions/24809391/trying-to-connect-excel-2013-with-oracle-ora-12154

Oracle 10g XE error ORA-06413 : Connection not open when uses MS Excel Data Source

Hi fellas. . .
I have a little bit problem when i use Data Source on MS Excel
Data Source connect to ORACLE using ODBC.
My data source work find when i use WIN7 
but it does not work properly when my client uses WIN10.

and then i find the error
The error is caused by the paranthesis in the path name.
C:\program file (x86)...
workaround: create a junction link

1.

from: command line execute

C:>mkLink /j "Program Files x86" "Program Files (x86)"

and then

2.

Restart your PC and fix the (or create a new) shortcut with new path (C:\program file x86...)

3.

Done!

#https://stackoverflow.com/questions/23003631/error-ora-06413-connection-not-open