Excel .xlsm + Run time error 1004 Initialization of the data source failed

[Shaimaa T]

I am accessing a client .xlsm file from my machine and it works fine.

The client complains that he received a Run time error 1004 : Initialization of the data source failed.

So on trying on a different machine(connected to client's network) , I was able to reproduce this error.

I just don't understand how the very same file with the data source is connecting and working fine on my local machine whereas failing on the client network.

The .xlsm file on opening has data part(from access, from ..., existing connections) enabled then in a few seconds greyed out.

Any help please?

 

[Rx_]

Are you in excel accessing a shared client excel data file, or in Access accessing an excel file?

The data drivers including ODBC can cause something like you describe.

 

[Shaimaa T]

It turned out that Oracle was not installed on the client's machine