Excel to SharePoint 2013 O365 Web App
Posted on 2015-01-15
Have access web app. Connects to excel well enough, when on my machine using correct SQl 11 native driver, etc.
Now want users to be able to open the spreadsheet from SharePoint and have it refresh just as it does on my machine. Can do if "visit" each users computer, install the driver and make connection, etc. Essentially just want the spreadsheet to connect to the server side query and present the data.
Isn't there a simpler way that will connect excel (read only of course) to what is essentially SQL on O365?