Excel Services supports workbooks that are connected to external data sources. By saving them centrally in a data connection library file on the SharePoint Site, other people could also use the same connection method to view and interact with your data.
To do that you will need to export the data source connection files to SharePoint Site as following:
- Open the excel
- Go to Data tab and click on the Connection Properties menu for your worksheet
- Click on the Definition tab and then click on the Export Connection File button on the bottom
- Save the file on a SharePoint site with Office Database Connection extension (*.odc)
- Once the data connection file been saved on the SharePoint site, the location of the connection file should be changed and pointed to the SharePoint Site
- Now you could Save and Publish your Workbook to SharePoint site by Click on the Save & Send menu
Once you did that, other people from your team/company can view live, interactive workbooks you created by using the browser on the SharePoint site.
