This happens when you are trying to connect to source like Excel from 64 bit SQL Server, it works well had it been 32 bit.

As a workaround, you could use...