Have a situation when I try to connect to the Oracle Database via an Excel Spreadsheet provided to me, I receive an error.
I go to Data Tab - Refresh All - immediately I receive an error Initialization failed for Data Source.
I was told all I needed to do was ensure my tnsnames.ora file was updated, which it is, I use SQL Developer and TOAD without a problem.
How can I get this to work? Any insight will be helpful. All works fine on the laptop of the engineer that provided the Excel Spreadsheet.