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.
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.