Is there a way to share workbook that has database connections to pull live data from database. The database I am using is SQL server and excel version is 2010?
Is there a way to share workbook that has database connections to pull live data from database. The database I am using is SQL server and excel version is 2010?
If you are using ODBC & MS Query then the same data source needs to be defined on all devices sharing the workbook... if you are setting up the database connection string in the VBA then you should be good to go..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks