initialization of the data source failed

[saurab8]

I got a macro file, where I have linked data from another excel.
Both the macro file and other excel are created in excel 2016. When the macro file opens, the data from other excel is imported, as I have built a connection.
The issue I am facing is some of the users who are opening the macro file have excel 2013. So when they open the macro file, they are getting the error "initialization of the data source failed".
I am not sure what can be done to fix the issue. Please help.

 

[justin 00089]

This could be because the other people trying to use the macro file don't have access to the file with the data or don't have the saved in the same location as you. They may need to personalize the macro to properly extract the data from their own computer.

 

[saurab8]

Thanks Justin 00089 - but other users have access to the data and the location.
Both files are in same folder at a shared drive location.

After searching for hours I could only find the reason for the issue from this link: https://support.office.com/en-us/ar...8e6-baa0-4123bc1d6068&ui=en-US&rs=en-US&ad=US

But it does not gives me the solution to fix the problem.

 

[justin 00089]

Then yes, I think you would need to update the other computers to run excel 2016 and it should work fine.